Advertisement

06.03.2008 at 02:16AM PDT, ID: 23452485
[x]
Attachment Details

how can i filter Dimmensions in OLAP cube designing?

Asked by ICQFINAANCE in OLAP, Microsoft Excel Spreadsheet Software, SQL Server 2005

Tags: SSAS - anlysis services, OLAP cubes

Hi,
i have time dimmension on table that i have from 2000 untill 2010. i want the Excel user to see only the years 2005-2008 when he open's the view (see attached file for example)
i would like to know how to config/mannage this property design in SSAS when i procces the cube again.
the reason i'm not doing that in view (SQL server) because this dimmension is sharing in other cubes that i have (different cubes show different years...)

how can i do it?Start Free Trial
Attachments:
 
Example (excel side)
Example (excel side)
 
[+][-]06.03.2008 at 04:53AM PDT, ID: 21699385

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.04.2008 at 08:49AM PDT, ID: 21711291

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.05.2008 at 02:01AM PDT, ID: 21717370

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: OLAP, Microsoft Excel Spreadsheet Software, SQL Server 2005
Tags: SSAS - anlysis services, OLAP cubes
Sign Up Now!
Solution Provided By: rickchild
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628