Here I have a report
I hope to add a new column on this report in OBIEE and the result should be like below:
ProductID Price New_ProductID_Grouped
LCD1 12 LCD
LCD2 11 LCD
LCD3 10 LCD
TV 100 TV
GAME 50 GAME
I hope to show LCD* products as LCD in the New_ProductID_Grouped field.
Is it possible in OBIEE?
I hope to create the column and then do hierarch later.
Thanks in advance.
Yeah you can go with new logical column with expression and can use it for hierarchy so that you can treat it as one of the level.
ex: drill down column value LCD on click on that you can see LCD1, LCD2 etc..
Try to see the valid expression to define new column.
If helps pls mark