Search found 2734 matches

by tomok
Fri Jul 17, 2020 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Assessing instance/Cube Efficiency
Replies: 7
Views: 420

Re: Assessing instance/Cube Efficiency

By doing a count of 1 on each pass I estimated that adding up all the measures there are about 45 million populated cells. Though it says the number of Stored calculated cells is 4.5 million and the number of populated numeric cells is 3 million. So I don't know why when I run the TI it counts 45 m...
by tomok
Thu Jul 16, 2020 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Assessing instance/Cube Efficiency
Replies: 7
Views: 420

Re: Assessing instance/Cube Efficiency

So I created a view at leaf level and I am doing a cellput to a cube which includes the measure dimension to count the number of cells by measure. So the data tab is simply x=x+1; Cellput(x, 'CountCube', vMeasures, 'Count'); The process is really 'sticky' and at this rate might take all day. Sounds...
by tomok
Tue Jul 14, 2020 3:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube data into SQL table columns
Replies: 7
Views: 395

Re: Cube data into SQL table columns

The view used as the data source in your TI process needs to be configured to only have the C level measure in it. No need to have all the individual measures in it since you are going to retrieve them with the CELLGET.
by tomok
Tue Jul 14, 2020 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube data into SQL table columns
Replies: 7
Views: 395

Re: Cube data into SQL table columns

If you don't want to change anything in TM1 you can also modify your SQL to accomplish the same thing. In your SQL you have an IF EXISTS that searches for the existence of the record and, if it does not exist, adds it with no values for the measures. Then below that you do an UPDATE that updates the...
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: 395

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: 374

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: 1166

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: 1166

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: 1166

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: 1166

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: 674

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: 3931

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: 3931

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: 3931

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: 2610

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: 2610

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: 1544

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...