SAC Cross-Model Parameter for Date

[Ilya_G]

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?

[JefB]

For now, -until SAP improves- I use several data (or mutlti) actions per model and trigger them consecutively myself using scripting. At least that allows using same parameters/prompts to the user.

[Ilya_G]

Hi Jef, this sounds good. Could you please share some code extract for running MultiActions with a prompt populated?

[JefB]

Hi @Ilya_G, For multi action it's pretty similar as DataAction script example you can see here https://community.sap.com/t5/technology-blogs-by-sap/the-data-action-api-for-analytics-designer-beau...

[Ilya_G]

thank you, this will definitely work, but it requires a lot of scripting, including pop up, value help etc etc. And it seems quite a basic functionality everyone needs...