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 - 2006-04-25 : 04:14:00
|
| Hi,I have a dimension called customers having the following levels:ALL Level 1 CustType Level 2 Cust Rank Level 3 Cust NameSuppose that the possible CustTypes are "Potential" , "Active", and "Lost". Other than filtering out the non-required data using a view, is there any other solution which can be used to hide displaying Level 1 and below if the Custtype (Level 1) = "Potential"Thanks & Regards.-J |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-04-25 : 13:56:53
|
| You could design a new dimension with a dimension filter which filters out the unwanted customers.There could be a naming problem with this, if you already have a dimension with All the customers, and you want to use the same name for the dimension.You can get past this by creating a private dimension in the cube, but then you have 2 to administer.(You are using shared dimensions btw?)Alternatively you could implement dimension security, and allow certain people only to see "Active" and "Lost" members,and other people to see all the Customers.There are other issues with this, such as that you will want to create NT groups and assign the users to the correct group."See All Customers Group", "Don't see Potential Customers Group".And the testng is a bit tougher.rockmoose |
 |
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2006-04-26 : 01:26:44
|
| Thanks buddy.... I'm following you and i guess there are only 2 options here i.e. either use the security settings or filter out the data (on the view that the dimension is based).Appreciate your help and reply :)Thanks & Regards.-J |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-04-26 : 13:31:26
|
Yes, as far as I know.Here are some good links for AS:The operations guide is very good:[url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx[/url]And this guy has lots of good material:[url]http://www.databasejournal.com/article.php/1459531[/url]And of course Mosha's place:[url]http://www.mosha.com/msolap/[/url]That should set you up for a couple of years  rockmoose |
|
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2006-04-27 : 00:23:03
|
| Well a decade (+/- an year or 2) was what I had in mind :)Thanks for the URLs. The 2nd link (articles by William Peterson) is really a treasure. Have never used the 1st and the 3rd one (as far as I remember) but will try these out too.Thanks & Regards.-J |
|
|
|
|
|
|
|
|
Can I hide displaying a certain member?