Re: Help in Query

#1

The data that is being returned is hierarchical, however it is not being
display that way in the MDX sample viewer. You need to render the data
another way to see how the hierarchy is structured - how about a pivot table
?

"Abdul Nasir Khan" <a.nasir (AT) ieee (DOT) org> wrote

Quote:

I am new to MDX and OLAP.
I need help in Hierarchical data view of a dimension.
Below are 2 MDX queries based upon in FoodMart 2000 Database
------------------
//MDX Query 1:
select
{[Measures].[Amount]} on columns,
Hierarchize( {[Time].members }) on rows
from budget
------------------
//MDX Query 2:
select
{[Measures].[Amount]} on columns,
{[Time].members } on rows
from budget
------------------
I want the output Year, Quarter and Month in Hierarchical form. How
can I get it?

By applying Query1, I am not getting Year, Quarter and Month in
Hierarchical form. Though I am using Hierarchize function !!! Instead
I get the result in straight listing.

My MDX Query2 is without Hierarchize function and it produces the same
output as MDX Query1.

"What difference does Hierarchize function make then?"

P.S. I am using viewer "Sample MDX Application" shipped with Analysis
Services

Thanks

Abdul Nasir Khan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Help in Query

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Help in Query - 08-29-2003 , 09:50 AM