Search found 2730 matches

by tomok
Thu Jul 02, 2020 1:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 180

Re: SQL Query Length Limit for TI

why you dont create a SQL View and just import the View? Better yet, use a stored procedure. Each individual INSERT INTO statement is going to have to be compiled before execution. Depending on how often you call the query this can really add up. Stored procedures don't have to be compiled each tim...
by tomok
Mon Jun 29, 2020 8:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LogOutput fails where AsciiOutput runs fine
Replies: 3
Views: 289

Re: LogOutput fails where AsciiOutput runs fine

Have you ever done this before, meaning have a logging directory housed on a different server? Or is it just not working this time?
by tomok
Thu Jun 18, 2020 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing Quick view depending on cell drop down
Replies: 24
Views: 750

Re: Changing Quick view depending on cell drop down

No, but the elements are not changing dynamically when i select the dimension, i tried it That's probably because your TM1RPTROW formula in cell B17 is not set up properly to pull back all the elements in the dimension. I suggest making it MDX-based and have the MDX statement based on the dimension...
by tomok
Thu Jun 18, 2020 10:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing Quick view depending on cell drop down
Replies: 24
Views: 750

Re: Changing Quick view depending on cell drop down

=DBRW($A$1,$A4,B$3) Everything is working fine, when i am changing the dimension it is fetching all the corresponding attributes from that dimension But .... the elements are constant it is not changing, is there any function like DIMNM() to fetch elements from that dimension ? Maybe because this a...
by tomok
Wed Jun 17, 2020 8:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing Quick view depending on cell drop down
Replies: 24
Views: 750

Re: Changing Quick view depending on cell drop down

Your DIMIX isn't going to work because you have a circular reference. The second parameter in that formula is an index number, 1 thru whatever. You can modify the formula to be DIMIX(Server:Dim, 1)....DIMIX(Server:Dim, 2)...DIMIX)Server:Dim, x) or you can add the index number in a cell above and ref...
by tomok
Tue Jun 16, 2020 5:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing Quick view depending on cell drop down
Replies: 24
Views: 750

Re: Changing Quick view depending on cell drop down

Yes i understood, as i told i am very new to PAx and PAW, can you please tell roughly how to achieve it in the easy way, if you have time please Easy is a relative term. If you are new to Planning Analytics then it isn't going to be easy for you. Basically, you need to create an active form report ...
by tomok
Fri Jun 12, 2020 5:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Usign lookup value logic to calculate royalty
Replies: 1
Views: 617

Re: Usign lookup value logic to calculate royalty

Loading the rates by month is definitely the way to go. As to how to do that I am sure you have a number of options. First, I would make sure my time dimension has an alias for the month in the format YYYY/MM. This way you can compare months mathematically. June of 2020 (202006) will always be great...
by tomok
Tue Jun 09, 2020 11:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Age Calculation based on DOB
Replies: 18
Views: 3610

Re: Age Calculation based on DOB

So, you know the serial number of today's date, the serial number of their birthday, and the fact there are 365 days in a year. Do I actually need to do the math for you? I would first of all divide by 365.25 instead of 365. Where I live, we have the concept of leap years. After that, apply some ro...
by tomok
Tue Jun 09, 2020 8:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Age Calculation based on DOB
Replies: 18
Views: 3610

Re: Age Calculation based on DOB

Hi, Thanks for taking the time to respond tomok. I did ask if I had missed something! Which I still must be because I can't work out how your method gets me someones age, I can only apologise for that! So are you saying to store their Date of Birth as a serial date in the attribute cube and format ...
by tomok
Tue Jun 09, 2020 3:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Age Calculation based on DOB
Replies: 18
Views: 3610

Re: Age Calculation based on DOB

Hi, maybe its me but I just couldn't get DayNO or TimVl to work, too many out by 1. So I did the following (my date is in dd/mm/yyyy format): ['EmpAge']=S: If( Month( Subst(DB('}ElementAttributes_Employee',!Employee,'Date of Birth'),7,4) | '-' | Subst(DB('}ElementAttributes_Employee',!Employee,'Dat...
by tomok
Wed Jun 03, 2020 5:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting elements without any data
Replies: 28
Views: 2174

Re: Deleting elements without any data

Thanks for the response Tomok. The TI is only adding "Active" elements back in the metadata step, and not inactive. But, the issue is when the TI is run it crashes the server with the following error message in the log file TM1.Lock Attempt to acquire lock during commit or rollback . Basically, wha...
by tomok
Wed Jun 03, 2020 11:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting elements without any data
Replies: 28
Views: 2174

Re: Deleting elements without any data

The PROLOG section of TI process is below; ----------------------------------- DimName = 'Project List'; iElm = 0; #Unwind the dimension we are updating iElm = 1; ElmCount = DIMSIZ(DimName); WHILE(iElm < ElmCount); sElm = DIMNM(DimName,iElm); ChildCount = ELCOMPN(DimName,sElm); WHILE(ChildCount > 0...
by tomok
Fri May 29, 2020 12:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 22
Views: 1141

Re: Local Backup

Side track on email. Cloud PA do provide SMTP for sending email. See below: https://www.ibm.com/support/pages/planning-analytics-cloud-smtp-send-email-process-using-powershell-script This option wasn't there when we migrated to the cloud last Fall. Maybe my grumbling about it to our IBM Cloud rep h...
by tomok
Thu May 28, 2020 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 22
Views: 1141

Re: Local Backup

Alternatively you can use Powershell Compress-Archive cmdlet. All thee are available on Windows Server as long as PowerShell is not disabled. I recently tested this out on the IBM SaaS. Powershell is enabled (bear in mind that the remote session you log into is not where TM1/PA itself runs) and it ...
by tomok
Tue May 26, 2020 6:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Delete / Replace Attribute elements in }ElementAttributes Cube
Replies: 3
Views: 279

Re: Delete / Replace Attribute elements in }ElementAttributes Cube

Thanks tom, I understand attributes cube is no different . My question is how can i replace an alias column values through TI process . i tried DimensionElementInsert DimensionElementComponentAdd but when i do this i get "Error: MetaData procedure line (43): Dimension element name "Hyundai-Accent "...
by tomok
Tue May 26, 2020 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Delete / Replace Attribute elements in }ElementAttributes Cube
Replies: 3
Views: 279

Re: Delete / Replace Attribute elements in }ElementAttributes Cube

An element attributes cube is no different from a data standpoint than any other cube so it can be updated with a simple Turbointegrator process. Check the TI manual for instructions on how to write such a process.
by tomok
Fri May 22, 2020 11:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: import file from a specific network
Replies: 6
Views: 210

Re: import file from a specific network

Hi all, i have a Ti process, in that we are taking data source as .Csv file Recently we have moved into cloud and we have migrated everything into cloud and in here the file in shared location which has user name and password when i am trying to browse the file what i need to keep in The processing...