You will need to verify this answer but I would believe depending on the implementation you could save time on maintenance and changing the dimensions. As there could be say...

in 2005, is it possible to have the name of a level in a hierachy change based on a condition?

For example, in our corporation (which is Level 1), when level...

Solution found! I used a custom rollup which pointed the value to be the value of the leaf 'person' then I made the leaf person visible=false.

Thanks.

Mark

Attached is a word doc...

MS Press book Microsoft® SQL Server™ 2005 Analysis Services Step by Step is pretty good as a walk through from first steps.

Regards.

Mark.

😎

We are getting a bit closer. To simplify the process I started work with just three facts

Females 3.2

Males 2.1

Persons 5.0

So in my cube I want a dimension Gender.There...

The rounding is done like this

Location Sales(£) Sales (£1000)

Location119902

Location229903

Location325302.5

Location411401.1

Location511301.1

Location656875.7

Location756875.7

Location811401.1

Location911401.1

Location1023582.6

...

I agree with what Scot has said.

One Excel connection.

Three data flow tasks (each would have an Excel data source to get the data from that particular sheet).

Each data flow...

You may need to provide more details on the relationships. In addition a bit more detail on what you are hoping to see out of the other end.

This would...

Forgot to add this screen shot of relationships. Sorry most of it is blanked out. That is done as I do not wish to disclose all the details of the...

All attributes in the dimension have a default attribute relation to the dimension key (primary key Mon Proc Setting Seq). You can see this in the left pane and if...

With the dimension editor the three noticeable issues are the three blue lines under the dimension name and the hierarchy names. If you move your mouse over them you may...

Befor you deploy the solution could you take a screen shot of the dimension you are creating?

Do you get an explanation for why the deployment failed?

Thanks.

Ells.

I am not quite sure of what each table represents. I am not quite sure of what you are trying to achieve.

I think you are trying to create a...

Ok,

so if your best practice is to accept that the packages do you do anything in your design to make it easier to resolve once you have a problem.

Sorry about...

Phil,

thanks for the reponse. I tried to leave the question as open as possible. I guess I am looking to install some level of robustness, also to make it easy...