Forum Stats

  • 3,875,482 Users
  • 2,266,929 Discussions
  • 7,912,229 Comments

Discussions

Heirarchy not working for one Dimension

2»

Answers

  • USER1211
    USER1211 Member Posts: 3,104
    edited May 7, 2018 10:18PM

    The smart view extension can be downloaded from the simplified interface.

    You could also just export the sales person dimension to a flat file and check the properties for default and vehicle cube are both set to dynamic calc.

  • NSquare
    NSquare Member Posts: 10 Blue Ribbon
    edited May 8, 2018 10:16AM Answer ✓

    Can you try changing the storage type for "SalesPerson" dimension to Stored/dynamic instead of label only and check the result ? It seems to be a case of implied share

  • mb1824
    mb1824 Member Posts: 148
    edited May 21, 2018 7:13PM

    I tried exporting the dimension and couldn't identify any issues so I ended up just deleting all the members and starting from the beginning. This time I set Data Storage on top-level of [Salesperson] to be "Store" and everything worked but not sure if that was the required change

    Thanks for your help @USER1211 and @NSquare

This discussion has been closed.