cancel
Showing results for 
Search instead for 
Did you mean: 

Characteristic not showing up in PROD

Former Member
0 Kudos

Hi All,

I am facing a problem with WebI 4.0SP6 with BW 7.3.

I am using a couple of BW queries that contain hierarchies, and I have merged these hierarchies in the WebI document.

In my dev system everything on this side was working well.
After using the same query in my production system, something weird occurs:

My query does not show any dimensions.characteristics anymore when previewing/refreshing the data. The key figures are shown in the preview, but the hierarchy and the fiscal period that's in it as well aren't shown, and show up as bold in the report items..

Thanks in advance for your input!

Sjoerd

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Additionally, when copying the query on my prod system and deleting all variables, I am getting:

- results as expected when previewing the first time

- "cannot execute empty query, (QTJ 00521) (WIS 00000)" on the second preview.....

Former Member
0 Kudos

Update on my side...

When I include all of the fields in another report in the WebI document, and list them all there, everything seems to be refreshing and showing up perfectly....

Can this have anything to do with query stripping?

regards,

Sjoerd

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Yes, if there is bolding, then query strip is involved. (setting can be found in2 places, document properties and query panel)