SSAS-Q's-Only

SSAS
25.?
1. How to create the Dynamic Measure Group Partition from Partitioned Database Table in a SSAS.?
2. Display Actual Cost as ‘9999’ , if it is empty?
3. Diff bw set & Members.
4. Diff bw set & Calculated Members
5. Wt is Hierarchies and how to create it?
6. Wt are the ROLES in SSAS?
7. Wt is Named Set?
8. What is FAMSI
Fast Analysis of Shared Multidimensional Information
9. Wt is Measures, Calculated Measures, Derieved Measures?
10. Wt are the Dimensions used in your Project?
11. PARTITION AND NAMEDS SET
12. WRITE A QUEARY TO GET TOP 2 SALES USING MDX QUEARY
13. How many ways we can deploy SSAS Cubes?
14. WHAT IS DATA REGION
15. For analyzing the CUBE dimension values how many AS languages available ?
Ans: 4
        MDX, XMLA, DMX
16. Wt is Partition in SSAS?
17. New Features in SSAS 05,08,08R2,12?
18. Can you create a hierarchy for attributes in a different Dimensions?
Ans: yes you can create dimension wise also.
19. Calculated Members, KPIs?
20. Wt is SSAS & Why we USE?
21. How will you provide a MANY-TO-MANY relation to a cube?
22. How did you get NOT NULL values while writing a MDX query?
23. Roles in SSAS project?
24. You want to use a perspective in an MDX query. How do you select the perspective?
Use the Cube Selector in the MDX Query Designer to select a perspective.