DataSource: Bex Query.
1. I had launched the Dashboard Designer 4.0 Apllication.
2. Opened the "Query Browser".
3. Created the Query by "Add Query" option.
4. Provided the required System Information and credentials to Login into the BO Repository to access the BEx query.
5. Selected the Data source as “BEx” to access BEx query to create a dashboard.
6. Then added the required dimensions and measures in the query panel.
7. The preview of the data has displayed in Query panel.
8. Executed the Query.
Under Result objects, I could see the dimensions and measures.
9. But unable to load the data on Embedded Spreadsheet while I choosed the "Insert in Spreadsheet" Option.
Please let me know.
Thanks in Advance.