Forum Discussion

bilbrandon's avatar
bilbrandon
New Contributor III
2 years ago

Making calculation logic and equations visible to end users

Hello - Wondering if anyone has come up with a efficient way of providing visibility for end users into the calculation logic and/or equations that are being used by dimension members. For example:...
Methodology
db_pdx's avatar
db_pdx
Valued Contributor
2 years ago

A couple of suggestions:

  • Avoid GetDataCell calcs as much as possible as these have the least visibility
  • Use alternate hierarchies for calculated members rather than dynamic calcs as these can be drilled-down using the out-of-box drilldown functionality, viewed in the dimension browser, as well as used in QuickViews with additional member expansions
  • For your dynamic calcs, ensure you are populating the 'Formula for Calculation Drill Down' so that the business logic can be drilled from the out-of-box drilldown.
  • ChristianW's avatar
    ChristianW
    Valued Contributor
    2 years ago

    If you use the Member Formula Builder (part of Administrator Solution Tools) to create your calcs, it will creat the drill down path automatically for you.

  • bilbrandon's avatar
    bilbrandon
    New Contributor III
    2 years ago

    Great suggestions - thanks for your response!

     

    Thanks,
    Bil