Question Re: Sap Analytics Cloud (SAC) - Show filter variable defi... in Technology Q&A

Sap Analytics Cloud (SAC) - Show filter variable defined on Datasphere

RoccoCaliandro — Sat, 15 Mar 2025 16:07:24 GMT

Hi everyone,

I have defined an Analytical Model in with the following input variable populated through a prompt

I imported the AM model in and as soon as I open the report the system ask me to insert a value for the specific variable

So far so good. What I would like to now is to display this simple value on each row of my table. How can reach this goal?

Thank you in advance for your time,

Regards

Rocco

Re: Sap Analytics Cloud (SAC) - Show filter variable defi...

deshmukh — Mon, 17 Mar 2025 16:06:12 GMT

Hi @RoccoCaliandro

I think you can create a calculated object/field in the fx node in the fact view with the name 'Target Currency' and mention the below in the expression section and use that object/field in the SAC table row

= :Target Currency

This is nothing but basically you are assigning value the entered in the Target Currency input variable (in SAC) to the calculated object/field (created in fx node in datasphere). Finally using the calculated object/field created in fx node of datasphere in the SAC table row.

Re: Sap Analytics Cloud (SAC) - Show filter variable defi...

RoccoCaliandro — Mon, 17 Mar 2025 21:08:25 GMT

I tried to create an fx node in the fact but the variable is not accessible:

Re: Sap Analytics Cloud (SAC) - Show filter variable defi...

RoccoCaliandro — Mon, 17 Mar 2025 21:10:42 GMT

Hi @deshmukh I tried to create an fx node in the fact but the variable is not accessible:

Re: Sap Analytics Cloud (SAC) - Show filter variable defi...

deshmukh — Tue, 18 Mar 2025 02:24:34 GMT

sorry for not mentioning clearly. You need to create Transaction Currency input parameter in fact view and not in Analytical model and then finally create calculated column like I mentioned earlier.