Drop Down filter related question

building reports webintelligence
1

Hi All,
I have this complex requirement. We have Fiscal periods and Register Periods. Our Fact table has corresponding keys, and I have Date Dim that I aliased as respective periods and joined with Fact Table.
Now, in my report I’m supposed to show a drop down(filter), for the users to selct either Fiscal or Register periods, and they get the corresponding data.
From my Fiscal Period Date Alias Table, I created Fiscal Year and Fiscal Month Objects.
Similarly, from my Register Period Date Alias table, I created Register Year and Register Month Objects.

Now the problem is, how can I show the drop down on the view(Fiscal/Register). Do I need to use Derived Table concept for this or any suggestions you have.

Thanks for your help. Please let me know if you need more details.

BIDeveloper (BOB member since 2009-08-19)

2

You can have prompts selection for both the periods, pass values to one of the period and using the ‘ALL’ functionality for the other
But If you are looking for a drop down kind of thing in the report itself without refreshing data everytime to choose the periods, then try creating drill filters (change the report to drill mode)
.

haider :es: (BOB member since 2005-07-18)