Wednesday, March 21, 2012

Quering Fact table using MDX Queries

Is there any way that I can query the Fact table using the MDX queries. What
I want to do is to find whether a record exists in the fact table at a
particular level.
Thanks
Akber.
That would be the Drillthrough command (Docd in books on line)...Below is
the example from BOL
DRILLTHROUGH
SELECT [Warehouse].[All Warehouses].[Canada].[BC] ON ROWS,
[Time].[1998].[Q1] ON COLUMNS,
[Product].[All Products].[Drink] ON PAGES,
[Measures].[Units Shipped] ON SECTIONS
FROM [My Cube]
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Akber" <Akber@.discussions.microsoft.com> wrote in message
news:B1B53F76-5677-4176-A03D-FF8B19F65CF1@.microsoft.com...
> Is there any way that I can query the Fact table using the MDX queries.
What
> I want to do is to find whether a record exists in the fact table at a
> particular level.
> --
> Thanks
> Akber.

No comments:

Post a Comment