Ok... I'm not sure why the calculated member is setup that way then.  What is the calculation trying to do?  Is it just trying to show the grand total for all of the...

I suggest that you convert the excel to a csv file first for 2 reasons.  One, I have had many cases where values in an Excel datasource never make it...

Look at the "Date Name" scripts on this site.  I use this all the time by using an execute process task:  http://www.ericphelps.com/scripting/samples/

Though, it could probably be used in an...

What does the script need to do?  Just change the filename of a file that already exists?

I may be thinking about this wrong as my brain is fried from a long week.  But potentially, you could add Customer_ID as a measure in the cube and then...

Sure... I think you could do it with MDX by using the Descendants function to look at the lowest level values in combination with IIF to determine if the value...

I looking at your MDX query a little more, it looks like you must have a product with the same name in the [Sku].[Brand].&[150] and [Sku].[Brand].&[15] rollups.  Because the "ALL"...

It's really hard to troubleshoot MDX code without having the database handy to query, but I think your problem lies in the calulated member in you MDX query:

WITH MEMBER [Sku].[...

1st thing.... Analysis Services is not really designed to create a mailing list, so I would leave that out of your design considerations.  A mailing list is a job for...

I would calculate your measure at the lowest level.  In your case hours.  Then do a simple calculation to convert to days:hours.

Sorry... should have specified that the calulation would be a calculated member in the cube.  Otherwise the Days:Hours will not rollup properly.

So, in the dimension editor, level 1 should be set to Cust# and level 2 should be set to Line#.

With it setup that way, and after you do a full...

Are you trying to use two tables in the dimension editor?

Why not combine the tables into a dimension table that has multiple levels:

Cust#        Line#

1               1

1               2

1               3

2               1

2               2

Vijay,

If that's the case, you may want to consider Michael Earl's idea.  It will require rebuilding your dimensions and cubes though.  However, if you have a very large cube, performance...

If you can clarify your question I think we may be able to help you more easily.  How about some sample data as well?