Hello All - Any help is much appreciated. I have a star schema, fact QS joined to 3 dim QS (relational database). I have a requirement in the FM model where i have to create a filter that prompts for a value(Date field). This part is simple I wrote a prompt macro and added a filter on the 1st dim QS. But I have to apply the same filter on the other two QS's in the FM model which also have a data field. I could create one filter for each QS but user wants only one filter/prompt that should will apply the filter to other QS in the background.
Any ideas??
P.S:I have a date table in the database which has one row for every day would this help in anyway.
for the other qs you have to filter create a prompt macro as you did before, but just use the same name for the parameter. this was you will submit the paramer value once and applied to all 3 qs
I tried that it works but the problem is my package is ad hoc package and when i do this it prompts for a data when the user selects any field from the 3 QS's. I dont want that to happen it should prompt and filter the data only when the filter is dragged into the report all other time it should display all the results with out any filters.
I hope i am clear on the requirement, if not i can try to explain again.
Ah! Instead of adding the filter to the query subject(s), add a folder into your model alongside the query subjects and add the filter into the folder. Make sure you publish the folder with your package, and your users will then be able to drag in the filter from the folder when they need it.
Regards,
MF.