Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2005-01-14 : 08:03:38
|
| I have a dimension named Products with the following hierarchy:Type Sub Type ProductDue to requirements I want that a particular product, whose name is "Blank Product" should not be displayed when the user drills down to the lowest level i.e. the Product level.I tried playing with the Advanced Properties tab but could not make any progress and thus will be grateful for help. |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-01-15 : 05:34:56
|
| You could make the member name:case when "product"."name" = 'Blank Product' then null else "product"."name" endAnd use the option Hide Member If : No name.Or You could make the database store null (maybe '' would work too) iof 'Blank Product' for the ones you want to hide.rockmoose |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-01-19 : 15:33:18
|
| How to hide a member with the member's name of Joozh...You can't make this stuff upBrett8-) |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-01-19 : 15:55:25
|
| Don't You have anything better to do Brett ?that WAS funny though *LOL*rockmoose |
|
|
|
|
|
|
How to hide a member?