Help, I been trying to figure this out this problem for about a week
and just can't do it. I have 2 cubes, one where this works without
any problems and another where it doesn't. I compare the 2 cubes and
everything looks the same but I get 2 different results.

The problem is as followed:
In the cube I have 2 dimensions and when I bring out one of the
dimensions in to Pivot table service using OWC everything works great
but when I drag out a second dimension all the data disappears and the
drilldown "+" is not display. I can not drill down to the underlining
data. Only when I click on "Empty Row" in "Command and Options" will
the data and "+" shows up. This is not the desire effect.

In my other cubes this is doesn't happen. Below is more data to help
explain what is going on.

2 dimensions:
1) Company with 3 children CoA, CoB, CoC.
2) Product with 3 children ProA1, ProA2, ProB1.

ProA1 – 2 is assigned to Company CoA, ProB1 is assigned to CoB, and
CoC has no product assigned to it.

When I pull out Product on to a Pivot table using OWC (ver
10.0.0.4109) I see all the products and everyone is happy. But as
soon as I bring out the Company Dimension (in reality any dimension),
all the data disappears and there is no way to drilldown to it. When
I look at "Command and Options" "Empty Row" is not check. As soon as
I check it all the data shows up again. But all the products are
showing up for all the Company:
CoA ProA1
CoA ProA2
CoA ProB1
CoB ProA1
CoB ProA2
CoB ProB1
CoC ProA1
CoC ProA2
CoC ProB1

This is not he behavior that we are looking for. I'm looking for the
data to show up like this:
CoA ProA1
CoA ProA2
CoB ProB1

Only products that have data associated to CoA be display as well as
CoB. If this example CoC should never show up unless "Empty Row" is
selected.

Why am I getting the above results? I can't figure it this out, I
need help! Any help will be greatly appreciated.

Thank you,
Patrick Gill

Patrick,
you should have the following three tables (one fact
table and two dimension tables):

Product
PROD_ID PROD_NAME
1 ProA1
2 ProA2
3 ProB1

Company
CMP_ID CMP_NAME PAR_CMP_ID
1 Companyname Null
2 CoA 1
3 CoB 2
4 CoC 3

FACT
CMP_ID PROD_ID SALES
1 1 100.00
1 2 500.00
2 3 500.00

This should reflect the situation which you described
(adding sales as a fact measure). It would imply that
each part of the company can sell each product and that
in turn each product can be sold by each company (many to
many relationship).

If a product is genuine to one part of the organization,
you could as well create one dimension with product below
organization.

I you are using this design (or similar), you should not
have the problem you described.

HTH Lutz

Thanks for your quick response. But I fix the problem. I re-created
the cube using the existing dimensions and everything works the way it
suppose too. This isn't the first time I had to re-create a cube to
solve a problem. I hope Yukon fixes a lot of these little bugs with
Analysis Server.

Once again thanks a lot...
Pat

"Lutz Morrien" <lutz.nospam.morrien (AT) ocb (DOT) com> wrote