How can i connect to an mdx cube on my analysis Service by ASP ?
Printable View
How can i connect to an mdx cube on my analysis Service by ASP ?
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