Search found 14 matches

by nxw
Mon Feb 29, 2016 12:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: edit element name
Replies: 5
Views: 3403

edit element name

Hi All,

Whats the quickest way to edit an element name without having to recreate another element with the proper name?
by nxw
Sun Feb 28, 2016 10:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding in a list of elements into a dimension via active form
Replies: 22
Views: 14904

Re: Adding in a list of elements into a dimension via active form

Hi All,

Not to worry about users adding it in- this form is only intended to a set number of users within the data team.

It would be a set data source - as in a list from a vendor pricelist.
by nxw
Fri Feb 26, 2016 4:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Event listener or tracking changes within cells
Replies: 10
Views: 7534

Re: Event listener or tracking changes within cells

Thanks, I'll give that a go.

I've been assigned the role of administrating the systems, ironically I am new to them. Planning ..well "hopefully" I get approved for some training for TM1 with these guys who we sometimes use for consulting work:

http://cubewise.com/
by nxw
Fri Feb 26, 2016 4:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding in a list of elements into a dimension via active form
Replies: 22
Views: 14904

Re: Adding in a list of elements into a dimension via active form

They are new elements that do not exist in the dimension - I'm trying to push them in from the active form.
by nxw
Fri Feb 26, 2016 2:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Event listener or tracking changes within cells
Replies: 10
Views: 7534

Re: Event listener or tracking changes within cells

What about if someone has gone and cleared the data from some cells?
by nxw
Fri Feb 26, 2016 12:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Event listener or tracking changes within cells
Replies: 10
Views: 7534

Re: Event listener or tracking changes within cells

Thnx - where can i find this transaction log?
by nxw
Thu Feb 25, 2016 11:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Event listener or tracking changes within cells
Replies: 10
Views: 7534

Re: Event listener or tracking changes within cells

Thank you Alan for your input.

I was wondering if there is any way to perhaps also qualify these changes eg.

xx changed Brand name from xx to xxx?
and all the other attributes against the leaf element being (product barcode)?
by nxw
Thu Feb 25, 2016 10:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Event listener or tracking changes within cells
Replies: 10
Views: 7534

Event listener or tracking changes within cells

Hi All, Just wondering, are there any event listeners or anything available in the form of when changes are made to cells, I can track these and quantify these? I'm monitoring changes in a cube where there are writable cells which the data capture team populate but I just need to ensure any changes ...
by nxw
Thu Feb 25, 2016 10:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding in a list of elements into a dimension via active form
Replies: 22
Views: 14904

Re: Adding in a list of elements into a dimension via active form

hI gtonkin, Thanks everyone for your feedback so far and being patient - it is really new to me so I probably am going to have a lot of dumb questions :P. 1) I am trying to add new elements to the consolidation 'ALL Product SKU' within the MAP Product SKU dimension. 2) The classification is permanen...
by nxw
Thu Feb 25, 2016 6:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding in a list of elements into a dimension via active form
Replies: 22
Views: 14904

Re: Adding in a list of elements into a dimension via active form

Thanks.

I'm not sure what the code would be does this work?

cDimT = 'MAP Product SKU';
cDimLeafTotal = 'All Product SKUs';

DimensionElementComponentAdd ( cDimT , cDimLeafTotal , pProductSKU , 1 );
by nxw
Thu Feb 25, 2016 5:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding in a list of elements into a dimension via active form
Replies: 22
Views: 14904

Re: Adding in a list of elements into a dimension via active form

What i'm more stuck on is screen shot one - what would the process be for inserting elements into a target consolidation and target dimension based on a list in excel?

Does the excel file have to be closed?
by nxw
Wed Feb 24, 2016 10:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding in a list of elements into a dimension via active form
Replies: 22
Views: 14904

Re: Adding in a list of elements into a dimension via active form

Hi all- appreciate your input. I think perhaps if you look at this screen shot here it may be easier to decode. I've got 3 screen shots here: 1) MAP Product SKU - is a screen shot of the cube and the respective dimension I want to push it into. It is a mapping dimension for us to feed all our produc...
by nxw
Wed Feb 24, 2016 3:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding in a list of elements into a dimension via active form
Replies: 22
Views: 14904

Adding in a list of elements into a dimension via active form

Hi everyone, I want to create an active form where I can send a list of numeric leaf level elements into a target consolidation within a dimension. Any ideas ? I was thinking either using a DBS formula or using an action button linked to bedrock add? I'm trying to create a form to push new products ...