Hello everyone,
Does anyone know if it's possible to create calculated categories in a DMR? Just like the ones you can create in a Transformer Model after generating categories and simply dragging to create a new one and then sum two categories or whatever. I have a dimension full of accounts and I would like to create "new" ones that are actually a sum or a calculation between others.
Thanks in advance.
Two ways come to mind.
Create a calculated item in a query subject. Use that in the dimension map.
Drag an item into your dimension map. Double-click the item in the map. In the lower right, you can click the ellipsis to the right of "Source" for the role you want calculated and edit the expression.
Because it is more-or-less obvious in the FM UI without going into a dialog, I think the first is a bit more obvious and thus maintainable for a modeler who may or may not know or remember where the calculation is when using the 2nd method. Either way should work, though.
Thanks for your reply bdbits but I think you got my question wrong, what I need are calculated categories in my tree, those must be like new members that represent some numeric calculation based on other members from the same dimension, just like the ones you can create in Transformer. What you´re describing are calculations or attributes, not something to "create" or "append" a new category/member to my dimension.