In one of our dashboards, we had to use a dashboard prompt to allow users to pick a value and display the report accordingly.
The prompt in question is - Year Name and is part of our Time Dimension. The Fact table is properly connected to the Time Dimension.
When I dropped the TimeDim.YearName in to the Dashboard prompt, I was expecting the results to be constrained for those records in the Fact Table. Let me explain,
The Time Dimension has data ranging from 1990 through to 2099.
The Fact table has data starting from 2001. If i write a SQL selecting TimeDim.YearName, joining Fact to Time Dimension it will only show distinct years from 2001.
But in OBIEE, when I execute the prompt it was listing all the available Years (distinct) in Time Dimension ie 1990 through to 2099. This is not what I was expecting.
After mulling over different things, I finally got it working but I am not sure that is the way. What I done is -
In the RPD, in the BMM, I explicitly specified both TimeDim and Fact table as Sources, and explicitly created the Join condition. Once I have done this, the results are as I was expecting.
Please feel free to comment if I had missed anything obvious.
Subscribe to:
Post Comments (Atom)
-
I have been playing around with the OBIEE repository for a demo project at current client assignment. I have been trying to use the "wh...
-
After installing Oracle DVD, I started playing around with the connections to various data sources. With the new release, the connections ... -
I have been working on a client assignment to implement OBIEE and design and develop dashboards and get them up and running. One particul...
No comments:
Post a Comment