dynamically mapping the qaaws connection data to excel cell based on rows

[Former Member]

Hi All,

I am developing a xcelsius dashobard using QAAWs connection

for example i have dimension STATE so i can directly map to excel cells (range of excel cells) in the connection tab.

But this data can increase in future, how to give exact excel cell mapping based on the returned records from the connection ?

People suggesting to give max range of cell selection in the EXCEL this can be a work around solution. is there a way we can give exact cell mapping based on the another parameter that we get from QAAWS connection ( ie Fetched rows) can we use this ?

[Former Member]

Hi Raju,

Cell mapping in Xcelsius cannot be dynamic. You need to forecast the number of rows that may come in and have maximum cells mapped. By using "Ignore Blanks Cells" in charts and selector components we can make the visibility dynamic.

Regards,

Ameet