dimensions...how to

dimensions...how to

• Kristy2610

  In ADOMD, you can get the members of a level by using the Members property of the Level object or the Children property of a Member object. However, this can get slow if a level contains a great deal of members simple due to the volume of data being requested. Another way to get a set of members is to use an MDX query. This is a little bit more work in generating the MDX, but allows more flexibility in controlling the members you retrieve and what properties are requested for those members.

  Tips for generating MDX queries to retrieve members:

  • Place and empty set, {}, on one axis of the query to avoid the cost of calculating any cell values.
  • Use the SUBSET MDX function to limit the range of members returned.
  • Use the ADDCALCULATEDMEMBERS MDX function to include calculated members in the set of member children or level members
  • Include any properties you wish to retreive for all members in the DIMENSION PROPERTIES clause of the MDX.

  Example:

  SELECT SUBSET( FILTER( ADDCALCULATEDMEMBERS( [Employee Dimension].[Employee].[All].CHILDREN ), ( LEFT( [Employee Dimension].[Employee].CurrentMember.Properties("Last Name"), 1 ) = "c" ) AND ( LEFT( [Employee Dimension].[Employee].CurrentMember.Properties("First Name"), 1 ) = "m" ) ), 0, 501 ) DIMENSION PROPERTIES MEMBER_NAME, MEMBER_TYPE ON 0, {} ON 1 FROM [Foodmart 2000]

  
  
  

• Sahir Shah

  thks matt..

  however i'm still having problems. i undestand that i have to use COM, i have made my vb6 program. i execute mdx queries and have results. my mdx as dimension in row and columns. but, for each mdx i must rewirte the mdx so that a new data in that dimension is considered. i would like to have ( say a combobox) for each dimension that i have and to choose the value that i want for that dimension. so my question is how to populate the combobox with all the values from one dimension ( like in analysis server when after processing a cube we can choose the values of dimensions)

  thks!

  
  

• Luis Esteban Valencia Munoz

  For accessing Analysis Services data from VB7 which is managed code you should use Adomd.Net. If you are using VB6 which is COM based, you'll want to use the COM ADOMD. Both provide similar object models that expose information about dimensions as well as allowing you to execute MDX queries.
  
  

• MTech8

  thks matt!!!!!

  you see, i have a huge statisct work to do ( based on a student' database in sql). last year i had do it with analysis server but it consumed a lot of time cause i had to select the members that i wanted ( pivot table). so this year, i'm going to use dts to fine tune the tables needed and a vb program so that it can register ( for futur use) all the mdx that i am going to construct. next year it shell be quite simple ( at least i hope!)

  thks again matt!

  
  
• dimensions...how to