Answer / Megha Saxena

To add a dimension to a cube in SQL Server Analysis Services (SSAS), follow these steps: 1) Create a Dimension Project Item by right-clicking on the Solution Explorer and selecting Analysis Services Objects -> Dimension. 2) Design the dimension structure by creating hierarchies, attributes, and keys. 3) Define relationships between the dimension and other dimensions or fact tables. 4) Process the dimension to populate it with data from a data source view (DSV). 5) Finally, add the processed dimension to the cube.

What is the sql server 2000 version number?

1 Answers  

---

Explain active/passive and active/active cluster configurations?

1 Answers  

---

What is ms sql server index?

1 Answers  

---

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

---

Differentiate between truncate vs delete in mssql?

1 Answers  

---

What are user defined datatypes and when you should go for them?

1 Answers  

---

What is lock escalation? : sql server database administration

1 Answers  

---

What do you understand by intent locks?

1 Answers  

---

Can we insert data into view sql server?

1 Answers  

---

hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

4 Answers  

---

What are the results of running this script?

1 Answers  

---

Write a query for primary key constraint with identity key word?

1 Answers   MindCracker,

---