Hi, I read a similar topic, but it does not seem to be the same issue and I am very new at Xcelsius dashboards, actually this is my first one.
Using the query browser my data is coming in in the format like A2 - C10 (columns). I used MATCH,INDEX with arrays to change it to the format in H2 - M10. Which is what I would like. When I go to do my preview no data is showing up, just blanks. I believe I read on another source that arrays do not work once you got to preview because it is a flash viewer.
The number of business groups is fixed, but each group may not have any entries for a particular month. This needs to be a 12 month rolling chart, so the dates can not be fixed.
Originally I was using SAP Netweaver BW connections which worked fine, but since we are going to be using this through BOE, I had to change to the Query Browser connections.
So how can a rookie get data from the layout in A2 - C10 into a layout like H2 - M10 that will show up on the dashboard? Thanks much.
Dashboards Version 6.6.7.0 Build 14,0,9,1387
index match array3.xls (37.0 KB)
JGKELLY 
(BOB member since 2012-11-30)
(BOB member since 2005-01-28)