Select
NON EMPTY
order({[datetime].[0104]}*
{[Dim 02].[all]}*
{[Dim 03].[all]}*
{[Dim 04].[a1],[Dim 04].[a2],[Measures].[Pv],desc)
} on rows,
{[Measures].[Pv]} on columns
from [Chart1]
NON EMPTY
order({[datetime].[0104]}*
{[Dim 02].[all]}*
{[Dim 03].[all]}*
{[Dim 04].[a1],[Dim 04].[a2],[Measures].[Pv],desc)
} on rows,
{[Measures].[Pv]} on columns
from [Chart1]
----
Select
NON EMPTY
order({[datetime].[0104]}*
{[Dim 02].[all]}*
{[Dim 03].[all]}*
{[Dim 04].[a1],[Dim 04].[a2],[Measures].[Pv],desc)
} on rows,
{[Measures].[Pv]} on columns
from [Chart1]
NON EMPTY order(
{[datetime].[0104]}*
{[Dim 02].[all]}*
{[Dim 03].[all]}*
{[Dim 04].[a1],[Dim 04].[a2]
} ,[Measures].[Pv],desc)on rows,
{[Measures].[Pv]} on columns
from [Chart1]