Condition in Drillthrough action

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Condition in Drillthrough action

Condition in Drillthrough action

Rate Topic

Display Mode

Topic Options

Author

Message

Raj-115466

Posted Tuesday, August 24, 2010 6:06 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 7:54 AM
Points: 5, Visits: 76

I have a cube with 2 measures

ActivityCount | MissingGender

10 | 2

At backend in fact table it goes like this

ActivityCount | MissingGender

1 | 0
1 | 0
1 | 1
1 | 0
1 | 0
1 | 0
1 | 0
1 | 0
1 | 0
1 | 1

When Drillthrough action defined and used in browser for "ActicityCount" it gives 10 rows back, but, for "MissingGender" it also gives 10 rows, how can I limit it to show on 2 rows where gender is missing?

Is it possible to do it without adding any dimentional filter?

Is it possible to do it wtihout creating a seperate fact table / view for the measure "Missing Gender"?

Thanks

Post #974043

sheila.etcuban

Posted Monday, October 01, 2012 6:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 22, 2012 6:10 AM
Points: 1, Visits: 6

We have the same problem. I have been trying to look for a solution. My drillthough is giving me everything when for example i am only expecting 2 lines/ rows.

Can someone help please???

thanks!

Post #1366520

« Prev Topic | Next Topic »

Permissions