April 14, 2013 at 2:13 pm
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???
April 29, 2013 at 11:00 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply