Date Formats in BI for TM1 Numerics

Post Reply
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Date Formats in BI for TM1 Numerics

Post by jim wood »

Guys,

We currently have a BI report built that points directly to a TM1 cube. In the cube we have dates that we store as numbers and format using the attribute. Previously we had the values formatted to one of the standard date formats. The business decided they want to change the format to MM/DD/YYYY. I was able to do this using custom formats. In the cube they display as expected but the report is now shoeing just numeric values.

We have tried to use formatting within the report but that is being ignored. We have tried removing formatting in TM1 but the we are still not able to format the date in the report. Guys do you have any idea why we are seeing this and what we can do to resolve it?

TM1 Version: 10.1.1
Bi Version: 10.2

The date in question is held within the dimension identified as the measure dimension fro the cube. There is no time time dimension set. For the said measure dimension there is no hierarchy but there is a defined hierarchy for another dimension in the same cube,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply