| T O P I C R E V I E W |
| saurav |
Posted - 02/09/2006 : 03:48:18
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
|
| 1 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 02/13/2006 : 23:31:09
Crossjoin()function and {}*{} are equivalents
HIERARCHIZE function is used in the expand mode so that members are presented in the proper dimensional order.
DISTINCT function is used in the expand mode so there are no duplicates in case of overlap.
|
|
|
Report Portal
