Search found 2737 matches

by tomok
Fri Aug 14, 2020 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC connection to EXCEL
Replies: 1
Views: 38

Re: ODBC connection to EXCEL

Do you have the 64-bit ODBC driver for Excel installed on the TM1 server?
by tomok
Wed Aug 12, 2020 2:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LOGGING for }StatsBy Control Cubes
Replies: 4
Views: 92

Re: LOGGING for }StatsBy Control Cubes

I can't think of any reason why you would want to log the activity in the {StatsXXX cubes because they are already set up to capture history. As to the other control cubes it depends on what type of activity you want to be able to track. I generally have logging set to YES for control cubes.
by tomok
Tue Aug 11, 2020 9:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LOGGING for }StatsBy Control Cubes
Replies: 4
Views: 92

Re: LOGGING for }StatsBy Control Cubes

Unless IBM has changed something recently then blank means YES for logging purposes.
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: 436

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

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

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

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

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

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

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

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

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

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

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

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

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

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