Answer / Ranjeet Kumar Sinha

Analysis Services is a component of SQL Server that provides capabilities for building, deploying, and managing online analytical processing (OLAP) cubes and data mining models. Features of Analysis Services include: cube design, which allows you to create complex multidimensional structures; data source views, which provide a view of the data sources used in your analysis; measures, which are numerical values that can be aggregated across dimensions; key performance indicators (KPIs), which allow you to measure business objectives and monitor their performance; and data mining, which allows you to discover patterns and relationships in large amounts of data.

How to transfer an existing table from one schema to another schema in ms sql server?

1 Answers  

---

What is advantage data architect?

1 Answers  

---

How to configure and test odbc dsn settings?

1 Answers  

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

1 Answers  

---

Determine when to use stored procedure to complete sql server tasks?

1 Answers  

---

What are the types of stored procedures in an sql server?

1 Answers  

---

What is exporting utility?

1 Answers  

---

what is the main difference between after trigger and instead trigger.

2 Answers  

---

What is the New in SQL server 2008?

1 Answers  

---

What is the difference between insensitive and scroll cursor?

1 Answers  

---

What is policy management?

1 Answers  

---

Where is trigger in sql server?

1 Answers  

---