Forum Discussion

alexandraMiz's avatar
alexandraMiz
New Contributor
6 months ago

BI Viewer Time sorting with custom Time Profile

I am trying to build a stacked bar chart with time on the x-axis. Time is being chosen via a parameter in the cubeview and then populating the 12 months prior to the time chosen as well as the time c...
BI Viewer
Dashboards
Parameters
Reports
KarlT's avatar
KarlT
Contributor III
6 months ago

I've noticed this in the past, although surprised you are seeing the correct start dates as I've always found them both to be based on the "Standard" time profile (the same seems to be true when you use "api.Pov.Time.TimeMemberDetail.StartDate" in a dynamic calc as well).

My solution was to just create a "calculated" field in the BI Viewer that did an offset to the times being brought in, then using this in my report.

As Fred says, worth raising with Support though.