Skip to Content
0

Variables - Using in Detail Variable

Sep 07, 2017 at 12:45 PM

26

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded

can you share data screenshot?

0
Former Member

Declares the measure - returns a ID Number.

Measure converted to Dimension

Trying to get the data from the table.

No error, just no results.

yf8jf.png (26.5 kB)
k7vxs.png (21.0 kB)
agrvv.png (21.5 kB)
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Sep 07, 2017 at 01:30 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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.

0