Forum Discussion

prateeks's avatar
prateeks
Frequent Visitor
8 years ago
Solved

Relationship between dimension fields

Hi, I have a very simple dimenion model and ssas cube as below. Now when I connect to cube using PBI desktop, I want to create a simple bar chart showing number of customers in each region. Basical...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    prateeks，

    I make a test with a table visual. It is possible to create a table visual using the dimension fields you mention. It is impossible to drag them to Values section of other charts in Live mode.

    Regards，
    Lydia

prateeks's avatar
prateeks
Frequent Visitor
8 years ago

Hi Lydia,

 

- There is no error message, only PBI only doesn't allow to drop the field into "Values".

- I am using connect live.

- Yes the relationship between DIM & FACT is 1:many

- I am using SSAS Multidimensional model, so cannot set the bi-directional filters.

 

Do I need to use tabular mode?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

prateeks,

I am unable to reproduce this issue when connecting to SSAS Multidimensional model with Connect Live mode. I suspect the issue is related to the relationship you create between dimension and fact tables. Please check the relationship in SSAS side.

Regards,
Lydia

  • prateeks's avatar
    prateeks
    Frequent Visitor
    8 years ago

    Hi Lydia,

     

    Its very straight forward relationship between DIM & FACT.

    DIM is directly linked to FACT. Please see below details - 

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      prateeks，

      I make a test with a table visual. It is possible to create a table visual using the dimension fields you mention. It is impossible to drag them to Values section of other charts in Live mode.

      Regards，
      Lydia