concat expression of function ?

Skip to first unread message

Marcello Giovagnoli

Dec 31, 2018, 2:58:29 AM12/31/18
Hi guys,
I would like to know if there is a way to define an attribute in one dimension where its label (label_attribute) would be a concat of two columns, so that it is interpreted by sql engine as:

concat (lastname, “ ", firstname) as fullname

For example I have in my model:


        "label": “Employees",
        "levels": [
                   "attributes": ["id", "lastname", "firstname"],

It could be something like:

"label_attribute”:{“expression”:  “concat(employees.lastname, ‘  ‘ , employees.firstname)”}

or even in another way, the important thing is that I can use the concat function on the joined table instead of adding a column named fullname in the fact table.

José Juan Montes

Dec 31, 2018, 11:07:22 AM12/31/18

No, Cubes does not support that.

The usual approach is to use database views or to go with a complete ETL process transforming your data for analytic purposes.


Jose Juan Montes

You received this message because you are subscribed to the Google Groups "Cubes" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
For more options, visit
Reply all
Reply to author
0 new messages