Retrieve with ASP

[dakoz]

Is there a way to retrieve just the names of the cubes in ASP? example :

budget
cost
something


and when the user clicks on it, the system takes him to process the cube

 

[MDXer]

I don't believe ASP gives you the ability to process cubes you may write you com object using dso that does it. I am not strong in ADO MD so I am not sure if you can get DB or Cube names, again a custom COM object could be written to allow this functionality

Paul

Paul

 

[rychand]

The following code will return all the cube names in a specific OLAP Database

<%
dim cat
dim cube
set cat=server.CreateObject(&quot;ADOMD.Catalog&quot
cat.ActiveConnection=<connectionstring>

for each cube in cat.CubeDefs
Response.Write &quot;<tr><td colspan=2>&quot; & cube.Name & &quot;</td></tr><br>&quot;
next
%>

However, I am not too sure on the processing part.

HTH.