Results 1 to 2 of 2

Thread: asp and mdx

  1. #1
    Join Date
    Mar 2005
    Posts
    3

    asp and mdx

    How can i connect to an mdx cube on my analysis Service by ASP ?

  2. #2
    Join Date
    Oct 2002
    Posts
    933
    It has been years without a single user question about this one. Th eonly reference i can fin dis ->

    <%
    szMDX = "with member [Measures].[Store Profit Rate] "
    szMDX = szMDX + "as '([Measures].[Store Sales]-"
    szMDX = szMDX + "[Measures].[Store Cost])/[Measures].[Store Cost]', "
    szMDX = szMDX + "format = '#.00%' "
    szMDX = szMDX + "select {[Measures].[Store Cost],"
    szMDX = szMDX + "[Measures].[Store Sales],"
    szMDX = szMDX + "[Measures].[Store Profit Rate]} on columns, "
    szMDX = szMDX + "Order([Product].[Product Department].members, "
    szMDX = szMDX + "[Measures].[Store Profit Rate], BDESC) on rows "
    szMDX = szMDX + "from Sales where ([Time].[1997])"

    Set X = server.CreateObject("Asp.DB")
    X.dbUnit = 1
    X.dbMode = "Grid"
    X.dbDSN = "Data Source=G1;PROVIDER=MSOLAP;INITIAL CATALOG=FoodMart 2000"
    X.dbMemoTextSize = "-1"
    X.dbMDX = szMDX
    X.dbNameMap = "0,Family;1,Department;2,Store Cost;3,Store Sales;4,Profit Rate"
    X.dbMagicCell = "2,,format=[currency]; 3,,format=[currency]; 4,,format=[Percent]"
    X.aspdb
    %>

    FK

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •