Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
flattened power pivot is not filtered

Unanswered flattened power pivot is not filtered

  • Monday, March 18, 2013 10:15 PM
     
     
    Sign In to Vote
    0

    I have 2 tables ( Customer and their branches)

    I created a flattened power pivot which contain data from customer table 

    I place the branch code from customer table as a report filter , and It work good , customer data is filter accourding the the slected branch code 

    Now I need to place the Branch Name as a report filter , When I did this The customer data is not fitlered any more , All customers are displayed whatever the branch name selected 

    I check and a FK is define between branch and customer , I do not know to fix this issue 

    khaled Mohamed

     

All Replies

  • Saturday, April 13, 2013 6:43 PM
     
     
    Sign In to Vote
    0

    This likely has something to do with the direction of the relationship you created in PowerPivot.

    Can you confirm the direction of the relationship (i.e.  which table in your relationship is listed as the Lookup Table)?

    Also providing a sample of your data, or at the very least the field names from each table, will also help you get a quicker solution to your problem.  Additionally, what measure/measures are you using in your flattened pivot?

    It sounds to me like your Branches table should be the lookup table, but the result you are seeing seems to indicate the customer is the lookup table currently.