hi
we have a cube built based on feed from framework manager which contains all the information which we build the cube. In one of the dimensions we have we have 3 levels - diagnosis, CMG and Mcc which diagnosis @ the lowest level, then cmg and mcc. This is text fields. what i would like to do is to add on the code fields for each of these levels- ie diagnosis code,cmg code , and mcc code.
This would make it easier for the user to drag in a code value and filter based on that for instance in query studio.
anyone with details instructions please let me know
regards
bunker
you can append the code along with the text. you could do this in FM or in Transformer.
Create a new Query Item in FM or insert a new item in Transformer and
[cmg code] + ' - ' + [CMG]
Also in Transformer, what i usually do is use the Code as the Source and the code+label as the Label field.
If your users are using Powerplay Client you could also use the Short Names and Description fields
hi
Thanks for the feedback. Can you provide some details as how i would use the code as the source in the transformer model? I am really new to transformer and would like to bring the code in so that when i complete a query report from the cube i would get the same results. Currently we have the same code which may be related to multiple text fields as some of the text fields have been modified over time.
ps. how would i be able to do in framework manager and bring this code as a dimension in the cube or join to the text field.
bunker