Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Create Temporary Table from OBIEE parameter inputs from reports

21
Views
0
Comments
user8718145
user8718145 Rank 1 - Community Starter

The formula for this table is: (Firstcount + Addcount) – Subcount = resultcount.

The Resultcount becomes the Firstcount, and the cycle continues.

In OBIEE the parameters entered are the Start_Date and End_Date.

The users can enter any random date to get the desired results. There is no underline table that the data is pulled from. Is there a way to accept the parameters Start_Date and End_Date from OBIEE and create the desired results in-memory based on the parameters? I guess, I want to know if I can create a global temporary table from parameters entered in OBIEE. Then, pull back the desired row? 

Tagged: