Does anyone know how to utilize Cross-Model Parameter for Date dimension?
It seems it is not working, since Date is a private dimension in each model
I have a scenario where we input data in multiple planning models (due to very different data structure I decided not to build all in a single model). After data input we need to reload data to "central model" with dedicated master data for consolidated reporting. And Date is a DA parameter of course, as this shouldn't be done for all the timeline each time. And I have to create a separate parameter for each model in my MultiAction for Date dimension. From the end-user perspective this results into terrible pop-up window with all the parameters to fill.
I had to build ZDATE public dimension with type Generic to be able to use it in cross-model parameter, but this approach has a lot of other difficulties and constraints.
Anyone have better ideas?
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.