I have several class in my universe containing objects (dimensions, measures) pointing on fields of a database table.
For instance the objects of the class "Grant" pointing on the table "Grant_T" and the objects of the class "Procurement" pointing on the table "Procurement_T".
I would like to create a dimension "Type" containing a fixed value in each class. For the class "Grant" it should be "Grant" and for the class "Procurement", it should be "Procurement".
I need this field for my different reports because when I do an UNION (query panel in Web Intelligence) on the different classes, I need to differentiate the results . I don't know how to create a dimension with a fixed value (not pointing to a database table field).
When I tried this formula
It's not working. The same with:
Apparently, the system needs to point on a field of the database table. But there is no field there allowing me to differentiate the type of the class.
Is it possible to do that? Could you please help me to find a solution?
Thanks for your help.