Search found 11 matches

by Cog1
Thu Jun 04, 2015 10:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Working with date type in Cognos TM1
Replies: 6
Views: 5306

Re: Working with date type in Cognos TM1

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
by Cog1
Thu Jun 04, 2015 8:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Working with date type in Cognos TM1
Replies: 6
Views: 5306

Re: Working with date type in Cognos TM1

Hi Trevor,

I have dimension with Date Format type

Image
by Cog1
Thu Jun 04, 2015 7:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Working with date type in Cognos TM1
Replies: 6
Views: 5306

Working with date type in Cognos TM1

I have a cube with a cell Date type in Performance Modeler when I want enter data I see picklist Calendar http://s18.postimg.org/jcb0y8aeh/image1.jpg but when I open Contributor I see a cell Simple type http://s27.postimg.org/lqzetn5f7/image2.jpg How I can to see peaklist Calendar in a Contributor?
by Cog1
Wed Mar 25, 2015 4:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX expression "CurrentMember" doesn't work
Replies: 7
Views: 7440

Re: MDX expression "CurrentMember" doesn't work

Please see attached file. I need create dynamic Subset in dimension Accounts, example:
Picklist = {FILTER( {TM1SubsetAll( [Accounts] )}, [Cube_A].([Dim_A1].[Element_1],[Period].[2015-01]) = 'True')}
by Cog1
Wed Mar 25, 2015 3:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX expression "CurrentMember" doesn't work
Replies: 7
Views: 7440

Re: MDX expression "CurrentMember" doesn't work

So doesn't suit me, I described requirements for dynamic Subset creation above. I need create Subset from Cube_A
by Cog1
Wed Mar 25, 2015 3:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX expression "CurrentMember" doesn't work
Replies: 7
Views: 7440

Re: MDX expression "CurrentMember" doesn't work

Thank's,
How I can create dynamic Subset in dimension Accounts?
by Cog1
Tue Mar 24, 2015 10:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX expression "CurrentMember" doesn't work
Replies: 7
Views: 7440

MDX expression "CurrentMember" doesn't work

Hi, Help to deal with operation of expression of 'CurrentMember'. I have 2 cubes - Cube_A and Cube_B: Cube_A : Period, Accounts, Dim_A1 Cube_B : Period, Company, Dim_B1, Dim_B2 Need create dynamic Subset in dimension Account which will be used as Picklist in Cube_B in dimension Dim_B1. I try to crea...
by Cog1
Wed Mar 18, 2015 8:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos TM1 cube caption
Replies: 1
Views: 2563

Cognos TM1 cube caption

Hi Everyone,

Do you use Cube caption in TM1?
I want to see in TM1 Contributor Cube caption name but I can see Cube view name.
by Cog1
Fri Sep 14, 2012 4:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI: Conditional Data Transfer with simple calculation
Replies: 2
Views: 2524

Re: TI: Conditional Data Transfer with simple calculation

Let me start by challenging this statement. You can have an additional version-type dimension in the cube, where one element will be rule-fed, another manually editable and both will consolidate to give the overall result. Users would simply input adjustments to amend what the general rule calculat...
by Cog1
Fri Sep 14, 2012 3:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI: Conditional Data Transfer with simple calculation
Replies: 2
Views: 2524

TI: Conditional Data Transfer with simple calculation

I am new to TI so may be the help request is an easy one. I sure hope so :) I have 2 cubes with source Data - ProductionPlan and Technology . ProductionPlan cube defines which product will be produced by each plant , and the Quantity to be produced: http://img-fotki.yandex.ru/get/6610/4595498.4/0_92...
by Cog1
Tue Sep 11, 2012 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: value compared to the dimension member
Replies: 8
Views: 8057

value compared to the dimension member

Hello
I have a cube_1
Image

I need to get the cube _2

Image

How do i do?