Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Merge between a dimension and a variable in webi

Is there a way to merge between a dimension  ( from data provider ) and a variable in  a  webi document
?

I have calmonth dimension in one query  and fiscal period dimension in another query . I create a variable  on fiscal period and truncated to get values in calmonth. But I wasn't able to merge on calmonth dimension and create variable .

Former Member
Former Member replied

Hi, unfortunately there isn´t. You can´t merge a dimension and a variable.

But I would ask, how is the definition of your fiscal period variable and how do you truncate to get the values in callmonth ?

I´m asking because , you can merge the calmonth dimension and the fiscal period dimension and create a variable over this merged dimension to truncate it .

Take a look at :How to merge dimensions where values from one Query has leading or trailing spaces.

Regards,

Rogerio

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question