8 Replies Latest reply: Feb 9, 2015 1:56 PM by Oleg Troyansky RSS

    how to restrict dimension best practice?

      good day!

       

      I've got 3 mln rows in fact table and 200 rows in dimension table "balance_dim" linking by sort of account field

      I want to make a sheet in my app dedicated to "loans" from whole "balance_dim"

       

      "loans" are only 80 rows from 200 rows of "balance_dim", and I do not want  users see unneeded rows in filter

       

      Is it normal to make one more dimension "loans_dim" with 80 rows in it and use it, and how about 4-5 dimensions like this, e.g. "deposits_dim" or "P&L_dim"

       

      Please, help me!

       

      In MS PowerPivot I can make disconnected table, and use it as a slicer, directly coding how table/chart should respond when user clicks something in a slicer

       

      thank you!