Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

circular dependency --help please

hi   i am just trying to relate tables using bridge table . where i am facing the circlaur dependency .   dim: feedyard sex ration   data table : feedyard sex ration index alex bike 1200 0...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    1. copy "dimension" and paste, then i get "dimension2" table,

        in this table with only one column, "remove rows"->remove duplicates

    2. copy "data" and paste, then i get "data2" table,

        in this table, click on the [index] column and select "Remove other columns", then Removed Duplicates

    3.in "dimension2" table, add a custome column

     

    Then expand this column

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous

1. when you add values in "dimension" or "data" table and refresh the dataset by clicking "Refresh All", it can automatically refresh in the "Query1".

 

2.

my first method is:

create a blank query-"Query1"

open the Advanced editor, paste my code, this will create a table which you want.

this new table "Query1" has joined "dimension" or "data" table together.

 

Yes, when "dimension" or "data" table refresh, table "Query1" will refresh automatically as shown above.

If you don't want table "Query1" to refresh upon the "dimension" or "data" table refresh,

you could uncheck "include in report refresh", then "close &&apply" , go to the "Data view", 

then when the "dimension" or "data" table refresh,  table "Query1" won't refresh but remain the previous values. (in Data view and Report view)

If you use "Query1" and "Query2" together to create the bridge table, you need to  uncheck "include in report refresh" for both  "Query1" and "Query2" .

 

Best Regards

Maggie

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi v-juanli-msft : can you provide steps for add column please

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous

    1. copy "dimension" and paste, then i get "dimension2" table,

        in this table with only one column, "remove rows"->remove duplicates

    2. copy "data" and paste, then i get "data2" table,

        in this table, click on the [index] column and select "Remove other columns", then Removed Duplicates

    3.in "dimension2" table, add a custome column

     

    Then expand this column

     

    Best Regards

    Maggie