Dynamics Community Forum Thread Details

Hi,

I have written some mdx query.

Its executing .Its not throughing any error .Its not returning any value

SELECT NON EMPTY { [Measures].[SJLLineAmount], [Measures].[QTY] }
ON COLUMNS, NON EMPTY { ([SBU].[SBUDes].[SBUDes].ALLMEMBERS *
[Marketing Unit].[MKU].[MKU].ALLMEMBERS *
[Function].[Funct].[Funct].ALLMEMBERS *
[Sales orders].[Sales orders].[Sales orders].ALLMEMBERS *
[Sales orders].[CreatedDatetime].[CreatedDatetime].ALLMEMBERS *
[Sales orders].[SalesTableConfirmId].[SalesTableConfirmId].ALLMEMBERS *
[Sales orders].[SalesTableEngNo].[SalesTableEngNo].ALLMEMBERS *
[ServiceJournalLine1].[POSTEDDATE].[POSTEDDATE].ALLMEMBERS *
[Sales orders].[SalesTableChasisNum].[SalesTableChasisNum].ALLMEMBERS *
[Sales orders].[SalesTableDeliverycity].[SalesTableDeliverycity].ALLMEMBERS *
[Sales orders].[SalesTableDeliveryName].[SalesTableDeliveryName].ALLMEMBERS *
[Sales orders].[SalesTableKMReading].[SalesTableKMReading].ALLMEMBERS *
[Sales orders].[SalesTableRegNo].[SalesTableRegNo].ALLMEMBERS *
[Sales orders].[SalesTableSalesResponsible].[SalesTableSalesResponsible].ALLMEMBERS *
[Sales orders].[SalesTableServiceTypeGroup].[SalesTableServiceTypeGroup].ALLMEMBERS *
[Items].[InventTableItemType].[InventTableItemType].ALLMEMBERS *
[Items].[ITEMNAME].[ITEMNAME].ALLMEMBERS *
[Items].[Items].[Items].ALLMEMBERS *
[Service Journal Table].[SJTAccountNum].[SJTAccountNum].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM
( SELECT
(
STRTOMEMBER("[LEDGERPERIODTIMEDIMENSION].[Hierarchy].[Ledger period time dimension].&
[" + @Company + "]&[" + format(CDate(@StartDate),"yyyy-MM-dd") + "T00:00:00].PARENT")
: STRTOMEMBER("[LEDGERPERIODTIMEDIMENSION].[Hierarchy].[Ledger period time dimension].
&[" + @Company + "]&[" + format(CDate(@EndDate),"yyyy-MM-dd") + "T00:00:00].PARENT")
)
ON COLUMNS FROM [WarrantyCube])
WHERE ( [Sales orders].[SalesTableJobOrder].&[1],
[Item groups].[InventItemGroupAutoMobile].&[0],STRTOMEMBER("[SBU].[SBUDes].&[" + @SBU + "]") ,
STRTOMEMBER("[Marketing Unit].[MKU].&[" + @MKU + "]"),
STRTOMEMBER("[Function].[Funct].&[" + @Function + "]") )

Its not returning any value.

Can anybody tell me what is the problem.

Community site session details

Mdx Query Not returning Value

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates