Hi Thomas, If my new table contains only the records that I need to show on report, then how will the interaction with Domain dashboard prompt would work. Say, If i select Domain 'X', the there would be no output. I'm not sure with new table structure, as you've mentioned above, how report will work. Thanks, Rituraj

Can you please demonstrate how my new physical table would look like that can answer these questions? Thanks, Rituraj

Hi Thomas, Can you please explain how pivoting the data would help me? The user wants to have interactive dashboard with Domain and Reason acting as dashboard prompts. So, business would like to see data for a particular domain and/or reason and/or no filters applied. Thanks, Rituraj

Hi, To answer your 1st question, I'm plugging this logical SQL in Analysis Simple SQL Statement box. The error then appeared. I'm not sure how to fetch the previous call time from the data available. RANK() function didn't help in OBIEE. Is there any way I can fetch previous call time? Thanks...

Hi, My table has data something like below - CUST_ID DOMAIN CALLTIME REASON C001 X 2017-01-02 12:30 PM A C001 Y 2017-01-02 2:46 PM B C001 X 2016-12-29 11:20 AM B C002 Z 2017-01-10 1:20 PM C C002 X 2016-12-28 11:10 AM B C003 Y 2017-01-05 10:24 AM C C003 Y 2016-12-30 2:40 PM D C003 Z 2017-01-05 10:40 AM E C003 X 2017-01-05…