Categories
- All Categories
- Oracle Analytics Learning Hub
- 29 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 237 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Create Temporary Table from OBIEE parameter inputs from reports
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?
