Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Use of MDX in SSAS Expand / Collapse
Posted Sunday, April 14, 2013 2:13 PM


Group: General Forum Members
Last Login: Monday, March 21, 2016 11:37 AM
Points: 187, Visits: 394
I have a database in sql 2008.Normally I see all data in database engine in form of tables.Now can I see my database in analysis service IDE when I connect as a normal table form?Bit confused !!!
and to view data from olap database is it compulsory to form cube and then query the cube using MDX?where MDX comes i picture while working with SSAS???
Post #1442132
Posted Monday, April 29, 2013 11:00 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, January 30, 2015 1:15 AM
Points: 53, Visits: 916
You have to go through some tutorial or books on how to build the cubes. You can't directly browse normal database using ssas. You will need to build the cube first, which is different kind of database (column store). To build cube, you need to build analysis services project, connect to the database, create data source view, build dimensions and cube, after that you can browse that cube in ssas.
Post #1447873
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse