BusinessObjects Board

Missing values in webi messing up the order in dashboard

other Xcelsius - Crystal Dashboard Design
#1

Hello,

I have an issue where some of the values missing in the webi report is messing up the order of display in dashboard.

For example for year 2000 and 2001

Year-------Country name-----------Value
2000…ABC…100
2000…EFG…200
2000…MAP…400

Year-------Country name-----------Value
2001…ABC…100
2001…MAP…400

When I am displaying this in a column chart, 2001 value MAP 400 will jump in the place of 2001 EFG which is non existant in webi.

I am using BIWS to pass the values to dashboard.
Any ideas? Appreciate your help very much.

Thanks,
Arun

Arun.K :us: (BOB member since 2011-10-18)

#2

We ran into a similar issue. I would recommend creating a custom SQL query in the WebI which uses a Cross Join so that you get all the possible Year and Country Name combinations. Merge your data sets together in WebI and make sure that you pull your custom query dimensions into your table not from you query that brings in the Value. This will add a row with 2001 and EFG although there will be no Value. This will then carry over to the Xcelsius.

Good luck!

psurphr :us: (BOB member since 2008-02-28)

#3

Thanks for the help Mitchell. I will try it out and update.
When you say Merge data sets you mean create two queries one with cross join and other with out cross join and make a combined query?

Arun

Arun.K :us: (BOB member since 2011-10-18)

#4

Sorry,

could mean multiple things. I actually meant Merge Dimensions. Merge your Year and Country Name dimensions. Just make sure when you pull the dimension into the report the the Year and Country Name dimensions are the ones associated with the custom query.

psurphr :us: (BOB member since 2008-02-28)