I have an organisation structure table that contains start and end dates so that I can use it to sequence financial reports with the structure "as of" a set date.
Along with this, I also have some slow moving dimension tables related to chart of account structure that also have start and end dates.
Now, I can build a model with this OK and when I create a report, I can add the selections ( "as of date between start orgstructure date and end orgstructure date and as of date between account structure start and end structure start) without any problem
but its much to complicated for my ad-hoc report writers to use.
Is there any way of setting up a parameter field in a model so that I can build the selections into the model itself so my users only need to feed it the date?
View Complete Post