Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RajChinna

    Evaluting result set using MDX

    Hi, I constructed a very basic MDX Query that generates a cellset/result set containing the member unique names for the 4 gender members ([Gender].[All Gender].[F],[Gender].[All Gender].[M],[Gender].[All Gender].[F],[Gender].[All Gender].[F]) in the Foodmart 2000 Sales cube: WITH Member...
  2. RajChinna

    Use function to add member to set

    Hi, I have created the following MDX query that queries the Foodmart 2000 Sales Cube: WITH SET [Test1] as' ({[Gender].[All Gender].[F],[Gender].[All Gender].[M],[Gender].[All Gender].[F]}*{[Marital Status].members})' SELECT {[Measures].[Unit Sales]} on COLUMNS, {[Test1]} on ROWS FROM [Sales] I...
  3. RajChinna

    Can't find writeback table

    Hi, Can anybody please suggest a method to retrieve the name of the writeback table using DSO and/or ADOMD? I was able to to find the name and location of the datasource using the DSOCUBE.dataources.item(1).connection.defaultdatabase property but I was unable to access the name of the writeback...
  4. RajChinna

    Accessing Name of Writeback Table

    Hi, I am attempting to retrieve the name and datasource of the writeback table (for a write enabled cube in Analysis Services) using DSO and/or ADOMD. I sucessfully retrieved the name and location of the datasource using the following property...
  5. RajChinna

    Cell Writeback.Error

    Hi, I am executing a cell writeback (without commit) to the Sales cube in Foodmart 2000 using the following syntax: Update Cube [Sales] Set ([Customers].[All Customers].[USA].[CA].[Altadena], [Education Level].[All Education Level].[High School Degree],[Gender].[All Gender].[F],[Marital...
  6. RajChinna

    ADODB Recordset Limitations

    No actaully the ADODB recordset DOES NOT return the correct results. In fact, the recordset DOES NOT return any data from the "ALL" level on any dimension in the row axis. Thus, if one were to construct the following MDX query: SELECT {[Measures].[Unit Sales]} ON COLUMNS...
  7. RajChinna

    ADODB Recordset Limitations

    Hi, According to our research, we have found several inconsistencies between the way the MS OLAP provider handles result cube data within an ADODB recordset and an ADOMD cellset. For example the following MDX query generates slightly different data using ADODB versus ADOMD: With MEMBER...

Part and Inventory Search

Back
Top