Hi,
Our Universe covers two business functions with a separate fact table for each of them. They are linked by means of a common dimension (customer). Both of these facts are snapshotted at different frequencies.
Our requirement is that there should be only one snapshot date object and NO contexts. For this, I have created two views on Date dimension linking each to the appropriate fact table and used aggregate awareness to choose the correct alias based on the object selection. That is, I have made the date alias (Date1) linked to Fact 1 in Star1 incompatible with all Star2 dimensions. This way Date1 will be used in the queries on Star1 and Date2 will be used if Star2 or both stars are queried.
The second requirement is, in a report with date prompt, the prompt values should show only the available snapshot dates. The problem is, in a report with a prompt on Snapshot Date, the list of values always shows the Snapshot Dates from Date1, even if an object from Star2 is selected. Is there anyway to make the prompt values to query the table used in the “Report query” instead of using the Level 1 table? I went thru the topics related to this, but I am not able to find a soln for this problem.
Thanks
vvenkat (BOB member since 2004-04-18)