Inquiry on Map component BEx Query as Data

[Former Member]

How Query Data could have been the alternate data to excel spread sheet data in the case as in the attached image file below. The Value for Y-axis has been chosen as some blank cell in excel just below one cell of the data required. But if the data source would have been BEx Query, how would have some one selected in case of the blank cells as in case Bex query data. It is just because the 'Destination' is also selected as one of the part of the blank

cells.

How would someone select the value for Y-axis if the data is query data in the same situation, if a map component is linked to a Column chart for showing Year wise Region Analysis. for details refer below image file attached

Regards

Ranendra

[former_member182541 · Accepted solution]

The option of having to select the data from the spreadsheet and query data in entirely different from fetching the data. when you are using the spreadsheet data by binding them from the excel you actually passing the data to the excel first and then you are carrying to the component, while using this you can do some manual calculations or some supported excel functions can be done for your benefits.

But in case of query data you don't need to do that, you can bind the dimensions & key figures directly to the components so it actually improves the data fetching were you don't have any manually calculations has to do done from excel level, everything has been done from BEx query level itself.

Hope this helps.