Skip to Content
avatar image
Former Member

Variables - Using in Detail Variable

This question is about Webi/BOXI 4.0 with no universe access.

Hello,

I have a measure variable to bring back the MAX reference number (its actually the result of a nested MAX statement), anyway

I have the reference that I needed.

Now I want to bring return a field using that reference, passing to a new variable to say

=[FIELD I WANT] WHERE (TABLE ID = MaxVar ID)

I get no results.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 07, 2017 at 01:30 PM

    try to drag all three object in the table along with Type variable and check what is coming?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I have done this anyway. I do this to check that the variables are moving between variable types.

      The original ID variable is a Measure

      Then I transferred it to a dimension (and tried detail too) - this works fine.

      The final variable that uses the reference is also a detail. as shown in the screenshots.

      =[FIELD I WANT] WHERE (TABLE ID = MaxVar ID)

      All have been added to the table. [FIELD I WANT] column is empty.