Controling 3 tables using 1 tables in powerpivot

[ymulyana]

Hi Guys,


Thanks a lot for accepting me in this forum. Currently work with PowerPivot in Office2010. And i have some Questions


i have 4 tables, 1 tables can control 3 table using slicer. see the tables below :


Tables 1
Segment Segment_Desc
A1 Coffee
A2 Tea
A3 Chocolate
A4 Chicken
A5 Meat




Tables 2
Segment Segment_Code
A1 Drinks
A2 Drinks
A3 Drinks


Tables 3
Segment Segment_Code
A4 Food
A4 Food


Tables 4
Segment_code Show_segment
Drinks Drinks
Food Food


When i relation in powerpivot, when i using slicer there's a problem, no result. Please hel me .


TIA(thanks in advanced)

 

[cyrilbrd]

Hi, just being curious, are your table a series of several rows with only one column?
You could create relations in between two or more tables within the PowerPivot Window if set on Diagram View, it would just be a matter then to click and drag the identical fields from one window to another...

 

[ymulyana]

Hi, just being curious, are your table a series of several rows with only one column?
You could create relations in between two or more tables within the PowerPivot Window if set on Diagram View, it would just be a matter then to click and drag the identical fields from one window to another...

Thanks in advanced, i have capture for the table relationship and powerpivot in excel.

Still error for the slicer if i click food or drinks .

see the url : http://vivezashop.com/images/Relationship.jpg

Regarsd

 

[cyrilbrd]

Sorry, I think a more knowledgeable member should give you better advise, I would be tempted to tell you that Pivot table do not handle well words, and your dataset contains no integer...

 

[GDRIII]

One of your relationships between Seg 3/Seg 4 is dotted which means it is inactive. If you double click on it there is a checkbox in the lower right corner to activate.

That might help with the slicer issue.

 

[ymulyana]

One of your relationships between Seg 3/Seg 4 is dotted which means it is inactive. If you double click on it there is a checkbox in the lower right corner to activate.

That might help with the slicer issue.

Thanks in advanced, i have fixed it. But actually when i click food the right powerpivot isnt change see the url : http://vivezashop.com/images/Relationship.jpg

Please help me.

tia
Regarsd

 

[scottsen]

Think you are going to have to share your workbook (dropbox, google drive, whatever)

 

[ymulyana]

Think you are going to have to share your workbook (dropbox, google drive, whatever)

Please donwload in : http://vivezashop.com/images/dataselect.xlsx

Regarsd

 

[scottsen]

So, in this simple example it is hard to say what you WANT to happen, but I'll say a few things:
* relationships have direction.
* as setup:
the dimSegment table applies filters to dimSegment2 and dimSegment3.
the dimSegment4 table applies filters to dimSegment2 and dimSegment3
there is NO relationship director or indirect between dimSegment and dimSegment4.
* So, the slicer isn't doing anything because the slicer on dimSegment4[show_segment] simply doesn't filter anything on dimSegment... they have no relationship.

It's totally possible the "direction" of some of your tables in reversed -- hard to tell in this made up data.

 

[ymulyana]

So, in this simple example it is hard to say what you WANT to happen, but I'll say a few things:
* relationships have direction.
* as setup:
the dimSegment table applies filters to dimSegment2 and dimSegment3.
the dimSegment4 table applies filters to dimSegment2 and dimSegment3
there is NO relationship director or indirect between dimSegment and dimSegment4.
* So, the slicer isn't doing anything because the slicer on dimSegment4[show_segment] simply doesn't filter anything on dimSegment... they have no relationship.

It's totally possible the "direction" of some of your tables in reversed -- hard to tell in this made up data.

Thanks for your direction, actually i have another way, but it will consume more data than the original one.

Regard