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

[RoccoCaliandro]

Hi everyone,

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

I imported the AM model in SAP Analytics Cloud 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

[deshmukh]

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.

[RoccoCaliandro]

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

[RoccoCaliandro]

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

[deshmukh]

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.