Design
Fact table design for “State Workflow Analysis”: Analysis Services Dimensional modeling
Aggregation design: useful tips
Trouble / Troubleshooting
Analysis Services 2005 migration tool: Custom member formula issues in migrated database
MDX
NextAnalytics and MDX : Part 1 - Swap Cells with Row Labels
Selecting dimension's default member based on a member property
Sorting members on member codes / member properties
Time Dimension: How to set Default Member to Current Month
Setting dynamic default member in dimension X based on the current member of dimensions Y
ADOMD.NET
Code : utility code for converting cellset to a data table
Others
Google specialized search for Analysis Services and MDX web resources integrated in my blog
Posts
2 comments:
Hi Ajit,
Can you please help me for optimizing the MDX query below..
Aftre applying MDX Studio Online sugesstions also Im not getting desired result.
It would be highly appriciated if you could able to help me
Thanks in Advance ...
MDX Query :
WITH
SET [FiscalMonths] as
EXCEPT(Ancestor(StrToMember("[Time Periods].[Fiscal Periods].[Fiscal Date].&[" + Format(Now(),"yyyy-MM-dd") + "T00:00:00]"),
[Time Periods].[Fiscal Periods].[Fiscal Month]).lag(11):
Ancestor(StrToMember("[Time Periods].[Fiscal Periods].[Fiscal Date].&[" + Format(Now(),"yyyy-MM-dd") + "T00:00:00]"),
[Time Periods].[Fiscal Periods].[Fiscal Month]),
Ancestor(StrToMember("[Time Periods].[Fiscal Periods].[Fiscal Date].&[" + Format(now(), "yyyy-MM-dd") + "T00:00:00]"),
[Time Periods].[Fiscal Periods].[Fiscal Month]))
SELECT {
([Measures].[Forecast Quantity]),
([Measures].[Total Quality Opportunity]),
([Measures].[6mos Shipped Quantity]),
([Measures].[6mos RA Defects Per Million Units]),
([Measures].[6mos RP Incidents Rate]),
([Measures].[6mos RP Cost Per Unit]),
([Measures].[6mos Total Quality Cost Per Unit])}
ON COLUMNS,
NONEMPTY(
CROSSJOIN({[FiscalMonths]},
{[Current Vendor Details].[Vendor Number].&[ASHLEY]},
{[Current Product Details].[Item SKU].Children},
{[Current Product Details].[Item Description].Children},
{[Current Product Details].[Item Code].Children},
{[Manufacturing Details].[Manufacturing Site].Children}),
[Measures].[6mos Shipped Quantity])
ON ROWS
FROM ( SELECT ( { [Current Product Details].[Current Manufacturing Status].&[Current],
[Current Product Details].[Current Manufacturing Status].&[New] } ) ON COLUMNS
FROM ( SELECT ( -{[Current Product Details].[Product Line].&[Other] } ) ON COLUMNS
FROM [Quality]))
Where
[Current Product Details].[AFI Finance Division].[All]
we are offering best power bi online training with job support and high quality training facilities and well expert faculty . To Register you free demo please visit
Power BI Online Training
Power BI Online Training Bangalore
Post a Comment