cancel
Showing results for 
Search instead for 
Did you mean: 

Measure does not display BW values - only 0.00

Former Member
0 Kudos

A universe with a Bex 7.0 query connection will only display $0.00 for the measure (key figure) in Webi. The actual amount, like $3,556.72, will not display. The actual amount will display on a Bex Analyzer. Also, the MDX trace of the webi report shows the correct amounts in MDXTEST. Other measures (key figures) in the universe display the accurate amounts. I have recreated the universe with the same results. Is there a setting on the InfoObject or perhaps universe that is affecting only this 1 measure - not the rest?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I troubleshot the issue and found a work around. I still do not know the root cause.

Solution:

1. On the bex query, remove the key figure from the structure. Save.

2. On the bex query, add the key figure back to the structure. Save. (This will give the key figure a new ID.)

3. On the universe, refresh. (Actually, I generated a new universe then dragged the updated measure to the old universe.)