Q:- In my fact table some dimension are related to some fact tables. For that dimension it shows same value for all attributes. I dont want to show values for this dimension.
Ans:- There is IgnoreUnrelateDimension property for measure group in dimension design cube.If you enable it then it will not show value for not related dimension to measure group. It will show null instead for that.
Ans:- There is IgnoreUnrelateDimension property for measure group in dimension design cube.If you enable it then it will not show value for not related dimension to measure group. It will show null instead for that.
4 comments:
Hello Mr Amish Manubhai Shah i have found your blog adress at sql.service.public.olap group and i have thought it will be interesting if i contact you, first in order to become friend, second i need help to build my data warehouse.
My name is Malek AIT TAYEB, student from Algeria, i have fellowing my studies in the french university by visio conférence from Algeria and now i'm preparing my project who is : Cube or Data Warehouse to analyze Humain Ressources of French LAFARGE Groupe, i have the data base test of this groupe but there is no more informations to help me to built my data warehouse. Please please help me it's Urgent.
Hi Malik
Nice to know about you. You are working on SSAS which is my favorite. Well what kind of help do you need from my side?
If you are stuck at some where and need my help then just mail me. I will do my best to help you at free of cost.
If you are completely novice and want to learn SSAS than I can give you good tutorials but it will be chargable.
Anyway feel free to give your inputs. I will be glad to help you.
Hello Amish, thank you for your request
Listen for the moment i want to demand you if you can send me the programme SSAS 2005 and SSIS 2005, because i'm working with DTS 2000 and Analysis Services 2000 who i want to change with the 2005 SSIS and SSAS, i think that will be more easily to perform my project.
Thank you for you help
Hi Malik
You can start with SQL Server 2008 instead of SQL Server 2005
You can download latest version of SQL Server ( DB Server/SSAS/SSRS/SSIS) from here.
http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx
Post a Comment