1

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

="Grant"

enter image description here

It's not working. The same with:

='Grant'

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.

Van Amburg
  • 1,207
  • 9
  • 15
coeurdange57
  • 715
  • 1
  • 8
  • 29

1 Answers1

0

Assuming you're using a database with standard SQL, the object's definition can simply be:

'Grant'

This will work in a WebI report, although it will generate a parse error in UDT ("Object not associated with a table", or something like that). The error can be ignored, but if you want to be able to parse successfully, click the "Tables" button and select the Grant_T table.

You don't need an equals sign in universe object definitions, only for WebI formulas.

Joe
  • 6,767
  • 1
  • 16
  • 29
  • Thanks, I do that you said but after selecting the table (via Tables button), I insert 'Grant' into the Select section and I click on Parse, but I'm still getting an error "Invalid Table name". – coeurdange57 Dec 09 '21 at 15:12
  • 1
    You have to select the table in Tables **after** changing the definition. Changing the definition will reset the table association; in this case where there is no table specified in the definition, the associated table is cleared. So if you go back into Tables now, it should work. – Joe Dec 09 '21 at 15:55