Till now I have been practicing dashboards using spreadsheet as Data Source. But here our consultants have used the BEx query as the data source, which I could n't practice as because i do not have login id and password which is required to "Add Query' in the Xcelsius. Please find the below attached image file and please help in making understand what exactly have they done using the 'Query Browser'.
Would be more thankful, if anyone can make me understand the Concepts of 'Result Objects', Filters and Prompts.
The Drill Down of the First Query i.e.HC_FTE_HC_A_Payscaletype