in the model the measure definition is as follows (I don't understand
chinese)
{
"name": "COUNT1",
"function": {
"expression": "COUNT",
"parameter": {
"type": "column",
"value": "attributeName.COUNT1"
},
"returntype": "bigint"
}
},
Le mer. 2 août 2023 à 05:31, Xiaoxiang Yu <[email protected]> a écrit :
> Do you check the answer by Hive/SparkSQL, do Hive/SparkSQL give the
> expected answer?
> If you have checked, I think you can give us you cube defination(CubeDesc
> in Json) and the SQL statement you queried, so we can discuss in detail?
>
>
>
> --
> *Best wishes to you ! *
> *From ：**Xiaoxiang Yu*
>
>
> At 2023-08-02 04:35:04, "marc nicole" <[email protected]> wrote:
>
> The measure is of type column (not constant) and is bigint. I selected the
> measure from the dropdown corretly as well. measure column returns 1 for
> all column values instead of actual values when querying the cube. What
> could be the underlying problem? cube or model defining? or maybe data
> source attribute types?
>
> Maybe I should create a lookup table with the fact table (which I am not
> doing so far)?
>
> Why the measure column in query answer is showing only 1 as values ??
>
>
>
>
