I am importing my Tempo data (accounts, account categories). Tempo Account Categories have a type to specify Capitalized vs Operational. In the Account dimension, there is a hierarchy that lets you group Tempo Accounts by Account Category. Is it possible to add Account Category type into that hierarchy so that it goes:
- Tempo Account Category Type (Capitalized vs Operational)
- Tempo Account Category
- Tempo Account
Thanks
Hi @alex.xm
Thanks for posting your question!
If you have already created a hierarchy for Category, you may consider Defining new members (at the Category key level) with the calculated member formula I have pasted below. Replace the highlighted part with the name of type you want to group (such as “Capitalized”)
Aggregate(
Filter(
[Account.Category key].[Category key].Members,
[Account.Category key].CurrentHierarchyMember.Name MATCHES ".*YOUR category name to group.*"
)
)
Best wishes,
Elita from support@eazybi.com