P
Patrick Gill
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
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