Hi,
I have the following mdx query:
SELECT NON EMPTY { [Measures].[FlowAmount] } ON COLUMNS,
NON
EMPTY
{
([Dim Date].[Fiscal].[Fiscal Quarter].ALLMEMBERS *
[TransferCase].[Tfr
Case Ref].[Tfr Case Ref].ALLMEMBERS *
[Dim
Wrappers].[Fac Group].[Fac Group].ALLMEMBERS ) } ON ROWS
FROM
( SELECT ( { [Dim Date].[Fiscal].[Fiscal Year].&[FY 13/14] } ) ON COLUMNS
FROM
[Cube])
It returns the following:
How can I get a count of the Tfr Case Refs by Fac Group and summed Flow Amount?
So in SQL
Select
Fiscal Quarter, Fac Group , count(distinct TfrCaseRef), Sum(FlowAmount)
Group
by Fiscal Quarter, Fac Group
TransferCase is a Fact Dimension based on Fact Table which contains the FlowAmount measure.
Thanks Jon
- Edited by JLJ1976 14 hours 16 minutes ago