Question:
I am having two similar challenges
1)I have a characteristic in an InfoCube dimension, this characteristic have a date attribute (display). In query I need to calculate number of days from the attribute date and today’s date. How do I achieve this, since DATE is display attribute I cannot use it in formula. Any special consideration while using date field to calculate number of days?
2)I have 0MAT_UNIT as a characteristic of a dimension, I need to use numerator and denominator (both display attributes of 0MAT_UNIT) values to calculate conversion factor. Since they both are display attributes, I cannot use them in formulas. The only solution is to make them Navigational?
Thanks for your help
Answer:
Hi,
For your 2nd question, there is a How-To document describing on Unit translation during query execution. Maybe it's not exact for your case but can bring some ideas to you.
BTW, do you really need 0MAT_UNIT included in Cube dimention?
If you only need the translate the DocumentUnit=>BasicUnit, you can do it in update rule. If you want to dynamic translation, you can use the How-To document.
Regards, Echo