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?