Using Microsoft Analysis Services Sample MDX application, we have written custom MDX queries. Report Portal allows us to view automated MDX queries based on the OLAP report created. The MDX syntax created by Report Portal is different than that what we have written so far. We would like to know which standard is better. For example - After reading about MDX syntax in general, I haven’t found use of HIERARCHIZE function.
Our MDX – Select non empty ({[Rx].[(All)].Members}*{[Group Type].[(All)].Members}
)}) on rows,
non empty {
[Measures].[Rx#],
[Measures].[PatDays],
[Measures].[Non Mug]} on columns
From [EPOC]
Report Portal MDX –
Select non empty HIERARCHIZE(DISTINCT({Crossjoin({
[Rx].[(All)].Members},
{[Group Type].[(All)].Members}
)})) on rows,
non empty {
[Measures].[Rx#],
[Measures].[PatDays],
[Measures].[Non Mug]} on columns
From [EPOC]
Any thoughts on this will be helpful. Thanks in advance,
--Saurav
|
Report Portal
MDX Creation in Report Portal
Posted - 02/09/2006 : 03:48:18
