Skip to content

Remove duplicate timeDimension field from result data #676

@paulmsinclair

Description

@paulmsinclair

Currently when I specify a Time Dimension in a query, the data in the result will include both this plus a duplicate value in another field which is named with a .granularity suffix.

For example if I specify a query like this:

{"timeDimensions": [{"dimension": "Cube.timeDimension", "granularity": "month"}], "measures": ["Cube.measure"]}]}

I am getting a result like this:

{"Cube.timeDimension.month":"2016-08-01T00:00:00.000","Cube.timeDimension":"2016-08-01T00:00:00.000","Cube.measure":1}

One of these 2 fields which both represent the same value, should be removed or there should be a way to tell the backend that we do not want the extra field returned in the result.
This is what I would like returned:

{"Cube.timeDimension":"2016-08-01T00:00:00.000","Cube.measure":1}

As a workaround I can remove the granularity from the timeDimension and specify the field as a regular dimension which enables the required grouping, and removes the unwanted extra field from the result data.

Metadata

Metadata

Assignees

No one assigned

    Labels

    backend:serverIssues relating to Cube Core's Server

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      close