Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Extracting information from Cube with MDX

Author  Topic 

cristianrb
Starting Member

13 Posts

Posted - 2006-04-05 : 05:48:14
Hello to you all.

I have a problem that i have to resolve and i dont quite know how to do it.
We are running at my firm an OLAP cube that shows us some information about the sales, the
stock and other informations. The olap cube is accessed with an excel sheet.

Some of the resulting data from the cube is needed to other reports. Is there a posiblity to extract the data from de processed cube?

I know i can connect to the cube with DTS.

Now, im am stuck with the MDX syntax...

The only thing i need is to extract the results of two columns:
Exemple:

Col1 Col2
154 4555
34657 355
345 9887


and so on...the numbers under the Col, are resulting values from the cube.
Of course, these values are filtered i need them only within a perioud and so on...


I hope i wasnt that confusing...

Thank you.

cristianrb
Starting Member

13 Posts

Posted - 2006-04-28 : 07:52:15
Hmm...so there is no one who can help me...
Go to Top of Page

sherin
Starting Member

3 Posts

Posted - 2006-05-05 : 08:24:01
can u elaborate on your cube. like what r the dimensions of the cube... and then maybe i'll be able to help u out.
Go to Top of Page
   

- Advertisement -