Working with date type in Cognos TM1

Post Reply
Cog1
Posts: 11
Joined: Mon Sep 10, 2012 10:41 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2010

Working with date type in Cognos TM1

Post by Cog1 »

I have a cube with a cell Date type in Performance Modeler when I want enter data I see picklist Calendar

Image

but when I open Contributor I see a cell Simple type

Image

How I can to see peaklist Calendar in a Contributor?
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Working with date type in Cognos TM1

Post by TrevorGoss »

Hello,
I have a cube with a cell Date type in Performance Modeler when I want enter data I see picklist Calendar
What excatly do you mean by "cell Date type"? There are only 3 cell "types" simple, string or Consolidated.

It may be the case that your concept of Date type may be misleading, because it is quite possible to have a picklist in a cell inside Contributor/AppWeb.

Trevor.
Cog1
Posts: 11
Joined: Mon Sep 10, 2012 10:41 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2010

Re: Working with date type in Cognos TM1

Post by Cog1 »

Hi Trevor,

I have dimension with Date Format type

Image
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Working with date type in Cognos TM1

Post by TrevorGoss »

I have dimension with Date Format type
Ah ok, you mean the formatting of the attribute, got ya.

As for the picklist, as long as you have a seperate attribute with the syntax of a picklist, such as "static:a:b:c" then it should appear in the cell as such.

What is your syntax for the picklist?

Thanks
Cog1
Posts: 11
Joined: Mon Sep 10, 2012 10:41 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2010

Re: Working with date type in Cognos TM1

Post by Cog1 »

I don't have picklist syntax You can see it in the last image. I get a drop-down calendar in Performance Modeler by default
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Working with date type in Cognos TM1

Post by tomok »

That drop-down calendar feature only works in Performance Modeler. Once you access your cube with regular TM1 then it doesn't exist.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Working with date type in Cognos TM1

Post by TrevorGoss »

I don't have picklist syntax You can see it in the last image. I get a drop-down calendar in Performance Modeler by default
I could not see the images in your post but now I understand what you mean.
That drop-down calendar feature only works in Performance Modeler. Once you access your cube with regular TM1 then it doesn't exist.
It all makes sense now, thanks.
Post Reply