September 12, 2008 at 2:17 am
Hi Guys,
I use SSMS,and then connect SSAS,I wanna do the MDX query about database.I haven't build any databases in SSAS,so I create one,there is only a step of creating new database,I put the database's name,and then OK,and then done.But I haven't any data,nothing in the database,only a name.how should I do to create a database in the SSAS.
appriciate for your help..
Rgds,
Shawn Qiu
September 14, 2008 at 10:49 pm
hi,
For getting into using MDX you must have a cube to query upon.SO first buld up a data cube using the tables availaible in the database.Then create a database named same as what you have used for the creation of a cube.Now deploy the datacube using the BIDS which will give you all the properties for you in the defined database. Now you can use the MDX query on the cube which you have created in the Analysis Service.
Regards
Vijay
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply