cancel
Showing results for 
Search instead for 
Did you mean: 

Variables - Using in Detail Variable

Former Member
0 Kudos

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.

amitrathi239
Active Contributor
0 Kudos

can you share data screenshot?

Former Member
0 Kudos

Declares the measure - returns a ID Number.

Measure converted to Dimension

Trying to get the data from the table.

No error, just no results.

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.