cancel
Showing results for 
Search instead for 
Did you mean: 

BEx Analyzer with multiple queries

Former Member
0 Kudos

Hello Experts !

I need to create a dashboard in BEx analyzer.

How do I insert multiple reports in a single worksheet.

Do we need to have same variables for all queries. There are 6 queries and I need report in single worksheet.

Thanks

Swati.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

To insert several queries in a single worksheet enter design mode and insert several analysis areas (the second button on the toolbar) in different cells. Each analysis area can be connected to different data providers which can be different queries.

You don't need to have the same variables in all the queries. But obviously if you want to enter a characteristic value only once you do. For example if all queries are to be filtered by Fiscal Year you should use the same variable in all so the user does not need to enter the same year several times.

Former Member
0 Kudos

How do I do it in BEx 3.x version ?

Answers (2)

Answers (2)

Former Member
0 Kudos

No need of having same variables , for inserting other quires in a workbook go to query design mode and insert table and attach your data providers/query's to those tables.

No need for same variables for all quires.

regards

KK

Former Member
0 Kudos

Help !