Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Avoiding multiple queries for similar data

Hi Guys,

I am creating a dashboard in Dashboards 4.1 using BIWS. I am publishing the following cross tab as a query from my Web Intelligence Report.

Employee Type

Dept. Name

Jan

Feb

Mar

Manager

A

$50

$100

$50

Manager

B

$120

$50

$70

Supervisor

A

$60

$40

$30

Supervisor

B

$70

$70

$80

Advisor

B

$40

$50

$60

The dimensions used in the cross tab are - Employee Type (variable), Dept. Name (variable) & Month (Merged dimension).

The measure used in the cross tab is - Commission Amount.

Now, in my dashboard, the first view is going to be a stacked column chart with Month on the X-Axis. The stacked chart is going to have Commission Amount by Dept Name.

In the second view, the X and Y Axis are going to be the same. But, the user gets to select the "Employee Type" from a radio button.

Based on the selection, the corresponding data needs to be shown in the stacked column chart.

Now, to achieve this, I am having to publish 2 queries (cross tabs).To get the first view, I am only using Dept. Name, Month & Commission Amount as my report columns. To get the second view, I am publishing the whole table shown above.

My question - Is there a way to create one query/table to get both views ? Your help is appreciated.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question