How can I implement following SQL logic on importing Excel sheet in EazyBI using MDX ->
"SELECT count(*), FROM GROUP BY "
Is it possible as I am not using any pre-calculated measure ?
How can I implement following SQL logic on importing Excel sheet in EazyBI using MDX ->
"SELECT count(*), FROM GROUP BY "
Is it possible as I am not using any pre-calculated measure ?
Can anyone please answer this.
Hi @Akash_Goel!
I’m sorry there has not been any answer so far.
If you have a custom mapping, at least one measure is a must (see more here https://docs.eazybi.com/eazybi/data-import/data-mapping#DataMapping-Rule#1–AtLeastOneMeasure). You can add a column with 1 for each row and that would give you a count that you can use for all other custom dimensions.
Lauma / support@eazybi.com