I am beginner in SSAS,Named set and Named query terms confusing me,What is the exact difference between named set and named query in SSAS.
Named queries are used at cube design level where we need to use a custom query as source for creating a cube dimension/fact table in data source view
Named sets are used in MDX queries to define a custom SET by giving an alias
Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?