Skip to Content

Merge variable with dimension in Webi

Hi,

I use a variable to do a calculation based on input controls. I try to merge thi variable with a dimension from an Excel query but it's not possible.

If I use a variable with a simple reference to a dimension, the merge is possible.

Is it normal ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 14 at 10:01 AM

    I don't have BI 4.2 SP06 version but according to below link it is possible.in the screenshot City was merged with excel provider "Cleansed City" variable.

    https://archive.sap.com/documents/docs/DOC-74364

    Can you recheck if data type of excel based variable and query object is same or not? Datatype of object/variable has to be same for merge.

    Add comment
    10|10000 characters needed characters exceeded

    • Already checked.

      The problem seems to be that there is calculations based on other measures in the variable.

      I used a simple test variable with a reference to a measure and it's not possible to merge it with another number dimension.

  • Jan 16 at 03:16 PM

    Try with creating dimension variable on top of measure variable and see if it will work or not.

    Add comment
    10|10000 characters needed characters exceeded