SSAS CUBE-How to Mapping Columns

Question

Hi all,

            I have created cube for Assembly product,the following problem i have faced,

my created cube like this,

		Day 1	Day 2	Day 3	Day 4	Day 5	.	.	.	.	.	.	.																Day 31
	Shift 1	17	17	17	17	17																							17
Mapping	Shift 2	36	36	36	36	36																							36
	Shift 3	66	66	66	66	66																							66
	Total	119	119	119	119	119																							119

I am having Day 5 Product number count,but cube display the count for all  Date.

my problem is ,i want display the existing count of product number for remaning dates.

How i map the column to date dimension,please help me on this.

cube display the record like this..

		Day 1	Day 2	Day 3	Day 4	Day 5	.	.	.	.	.	.	.																Day 31
	Shift 1	55	40	100	50	17																							17
Mapping	Shift 2	10	30	10	50	36																							36
	Shift 3	20	10	10	0	66																							66
	Total	85	80	120	100	119																							119

 

Answer 1

Hey,

Can you post your MDX here?

---

Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog

Answer 2

select

non empty

{[Measures].[Product Number]}

on 0,

non

empty

{[LT LAEMI VW PROD STATUS Cell1 Cell2 Shift].[Mapping].[Mapping]*

[LT LAEMI VW PROD STATUS Cell1 Cell2 Shift].[Cell1 Cell2 Shift].[Cell1 Cell2 Shift]*

[Time].[DayOfMonth].[DayOfMonth]*

[LT LAEMI VW PROD STATUS Cell1 Cell2 Shift].[Shift Date].[Shift Date]}

on 1

from

[Logic Apps EMI2 MDU]

Answer 3

I am not well practiced in MDX query....