Hi All,

I am new to OLAP.
I am trying to retrieve data from a fact table by using 8 dimension tables
for that cube.

Can i retrieve data from a fact table using MDX query?
I have an idea about retrieval of data using MDX query from dimension
tables.
Please help me to retrieve data from fact table.

Advance in Thanks,

Natraj.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005

MDX was designed to query against Cubes not relational tables.

You can use DRILLTHROUGH with MDX statement but I'm not sure it's what you
want.

Ohjoo Kwon


"Natraj" <natarajan (AT) eprocorp (DOT) com> wrote

Hi Ohjoo Kwon,

I want to filter records depending upon a particular measure.
Can i do it?

Thanks,
Natraj



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

If you mean "Retrieving the rowsets from data source that were used to
create a specified cell in a cube" by "filter records depending upon...",
Drillthrough can be a solution.

But if it means different ad-hoc queries case by case, you need to program
by yourself to create the customized SQL statements dynamically.

Ohjoo Kwon

"Natarajan Sennappan" <natarajan (AT) eprocorp (DOT) com> wrote

Thanks for ur kind information and help.

Natraj.

"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> wrote