I have an very urgent requirement to call table function as physical table in obiee rpd.and this table would become the fact table to join with the other dimension tables .
As the structure of the table function includes all the dimensions id columns and measure coloums.
And the function is doing on fly calculation by fetching the values from dashboard prompts.the parameters in the function is the dashboard prompts columns.
Please guide me to achieve the below requirement.please let me know if you need more information.
Thank you very much
Any idea on the above requirement please.