Welcome, Guest
Please Login or Register.    Lost Password?

Toggling option in Excel 2007 reports with CUBE as
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Toggling option in Excel 2007 reports with CUBE as
#1632
Toggling option in Excel 2007 reports with CUBE as 8 Months, 1 Week ago Karma: 0
Hi,
I am creating Excel 2007 reports from Cube. There is a drop down for “Customer hierarchy” and “Employee Hierarchy”(bcoz they are placed in the report filter of Pivot table).
The user should choose items either from the “Customer hierarchy” or from the “Employee Hierarchy”, but not from the both.
Is there any workarounds to accomplish this without using Macro?
selva
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1634
Re:Toggling option in Excel 2007 reports with CUBE as 8 Months, 1 Week ago Karma: 5
Hi Selva,

I do not think there is a way to do this, and also this would not be right way. You should design SSAS database so that it would work with any front end.
I would suggest that instead you would override measures so that if just customer or employee is selected, then you show measure values. If both customer and employee are below All level, then you show NULL or string stating "Select customer OR employee".

Here is sample MDX code (based on Adventure Works) that you could add to your cubes script to acomplish this:


IF NOT ( ([Employee].[Employees].CurrentMember IS [Employee].[Employees].[All Employees])
OR ([Customer].[Customer].CurrentMember IS [Customer].[Customer].[All Customers])
)
THEN
{AddCalculatedMembers(MeasureGroupMeasures('Internet Sales'))
, AddCalculatedMembers(MeasureGroupMeasures('Reseller Sales'))
}
= 'Select just Customer or Employee'
END IF;
VidasMatelis
Moderator
Posts: 208
graphgraph
User Offline Click here to see the profile of this user
SSAS-Info.com
Last Edit: 2009/12/24 06:18 By VidasMatelis.
Microsoft SQL MVP
www.ssas-info.com
The administrator has disabled public write access.
 
Go to topPage: 1
Moderators: VidasMatelis, dgosbell