CODEWITHSUNDEEP
c#-4.0adomd.net
Gowri24
Gowri24

Reputation: 23

How to get data from Cube (SSAS) using ADOMD without MDX query..?

we have a cube in our project, So far we are accessing cube via Store Procedure (Writing MDX query inside SP and Executing with help of Linked server). Now we have to acccess the cube without MDX query. I have reaserched a lot and found ADOMD where I can get cube information such as Dimension,Attribute and level.ADOMD providers, ADOCommand which executes MDX query and returns result set.Is there any other way to get data from cube without MDX query..?

Upvotes: 0

Views: 1104

Answers (1)

benliet
benliet

Reputation: 120

You can sent MDX, DMX and ASSL-Commands. So its possible to get data without mdx. But what do you want?

With the ADOMD.Net-Objectmodel you get "only" the metadata (also you can get the schemarowsets). For more you need any command.

Upvotes: 0

Related Questions