Data Range for Dashboards

[former_member197660]

Hello Forum

Am quite new to Xcelcius and have been assigned a task to create a DASHboard that would display the KPI's in the form of a line chart based on the data of an Excel file.

Based on the business we have four major product groups on which the management is expecting to see the turnover across the months in a cal year.

Now we gathered all relevant data in excel file in the following format :

Product Group Calmonth Turnover Profit

For four product across the year we had 48 data records in file which became the base of our line chart.

While preparing charts we defined four series in chart that represents each product group and determined the transaction value against each series in excel file manually after sorting data records based on Product group and Calmonth.

This manual selection of data ranges for a series worked fine.

Thus based on above fact the thing that wonders me is do we have to manually select the data range and sort the data according to the characters everytime as it was ok to do it for 48 records but how to control this if we integrate Xcelcius with BPC datasource or any XML file.

Can anyone please guide if there is any way to dynamically define the data range for series or if I am missing any basic thing while defining data ranges for a particular series ?

Thanks

Ashish

[former_member648661 · Accepted solution]

General recommendation is to reduce the complication on the Excel side of the dashboard and use as many as queries possible to get the data in the way you want that could be directly mapped to the Dashboard components.

I recommend you to perform the sorting in the Query Panel and get the data as close as possible that could be directly used. If you want to get one result set and work around with it, try to break this data by internal reference to other cells that can be mapped with components.

[Former Member]

use pivot table concept in excel it will automate your process

If this is not the correct answer,Please explain me in detail and show how data coming and data how you arranged.

[former_member197660]

Hi Venkat

Thank you for the reply.

Let me be more precise with the pain point.

I could create the chart by manually defining the data range for each series by for example

i) Sorting data for series

ii) Providing data range for each series manually.

The question is its ok to do these manual activity for an excel file having few number of records but it would quite tidy when we pull data from a either SAP-BI/ BPC system having many number of records and considering the fact we don't know the number of records that will be fetched from BPC is there any way to set the data range for a particular series dynamically.

Is there any way if the data range for a particular series can be determined dynamically to handle the unknown number of records coming from other different source.

Regards

Ashish

[Former Member]

Hi

Make data range maximum (recommended 512 rows) and use ignore blank cell option

Ignore blank cell option is available for most of the components in xcelsius in Behavior tab

then no need to worry how many records will come and sit in excel of xcelsius