Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Use of MDX in SSAS Expand / Collapse
Author
Message
Posted Sunday, April 14, 2013 2:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:07 AM
Points: 126, Visits: 236
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: Thursday, June 12, 2014 10:23 PM
Points: 53, Visits: 911
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