Search found 113 matches

by Jorge Rachid
Sun Jan 05, 2020 5:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advanced Rules Editor on PA
Replies: 7
Views: 3802

Re: Advanced Rules Editor on PA

Hi Wim, yes I know.
I hope that I can get used to it.
I will try the workspace.
Thanks
JR
by Jorge Rachid
Sat Jan 04, 2020 8:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advanced Rules Editor on PA
Replies: 7
Views: 3802

Re: Advanced Rules Editor on PA

Even if I can install the 32 bits version? That is not possible! It is awful only using the basic rules editor. There should be a way to solve that. It is hard to believe that everybody that uses PA can not use the advanced rules editor. Thanks Hi guys, I am facing difficult to launch advacend rules...
by Jorge Rachid
Sat Jan 04, 2020 8:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advanced Rules Editor on PA
Replies: 7
Views: 3802

Re: Advanced Rules Editor on PA

Even if I can install the 32 bits version? That is not possible! It is awful only using the basic rules editor. There should be a way to solve that. It is hard to believe that everybody that uses PA can not use the advanced rules editor. Thanks Hi guys, I am facing difficult to launch advacend rules...
by Jorge Rachid
Sat Jan 04, 2020 8:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advanced Rules Editor on PA
Replies: 7
Views: 3802

Re: Advanced Rules Editor on PA

Hi Alan, Tks for the reply. I take a look and the last version with tm1 architect client of 32 bits was PA 2.0.4. In my case I use the version 2.0.8. Do you know if there is any problem on using the 2.0.4 client version as I have the 2.0.8 installed on server? Thanks a lot. JR Hi guys, I am facing d...
by Jorge Rachid
Mon Dec 30, 2019 7:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advanced Rules Editor on PA
Replies: 7
Views: 3802

Advanced Rules Editor on PA

Hi guys, I am facing difficult to launch advacend rules editor on Planning Analytics version 2.0.8. I read several things on internet, including here, but I didnot find a solution for it. The tm1p.ini on Applix does not have the line "AdvancedEditRules" and if I put that after closing and ...
by Jorge Rachid
Thu Dec 12, 2019 8:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Region Problem After PA Migration
Replies: 7
Views: 3918

Re: Region Problem After PA Migration

I understand. Even doing this I already know where the problem is, but I don't know how to solve. The problem is that process understands the number on this format: 1,000.00 But in reality the number is on this format: 1.000,00. It only works when I change my region/area configuration of windows. Be...
by Jorge Rachid
Wed Dec 11, 2019 12:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Region Problem After PA Migration
Replies: 7
Views: 3918

Re: Region Problem After PA Migration

Hi Orlando, the version is 2.0.8. Maybe it could be something about the instalation, I don't know. I didn't ask IBM support because I am waiting the company that did the migration in the company that I work. Thanks! As I have said, when we change the region configuration of windows it works. We had ...
by Jorge Rachid
Wed Dec 11, 2019 11:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Region Problem After PA Migration
Replies: 7
Views: 3918

Re: Region Problem After PA Migration

Error log????? tm1server.log??? What do they say? Hi tomok, yes, we do have a log, but it didin't say much: "Data Source line (1) Error: Data procedure line (12): Error executing SQL query: "..." " As I have said, when we change the region configuration of windows it works. Than...
by Jorge Rachid
Tue Dec 10, 2019 8:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Region Problem After PA Migration
Replies: 7
Views: 3918

Region Problem After PA Migration

Hi guys, We have migrated TM1 version 10.2.1 to Planning Analytics and am facing problem on TI process that uses odbcoutput . It only works (using client) when the country and format of Windows is United States. If I chance the format to Portuguese (which is my case), the process does not work - the...
by Jorge Rachid
Mon Nov 25, 2019 2:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Question
Replies: 6
Views: 3582

Re: Rule Question

Hi, thanks for help! I am working on TI process but it is not working yet. I prefer to do the rule, but I am facing some difficult too. My dimensions of period has the hierarchy as you said. I put some screenshots here. On rule you would use the ELPAR function? Can you explain more? Thanks, JR. Give...
by Jorge Rachid
Mon Nov 25, 2019 2:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Question
Replies: 6
Views: 3582

Re: Rule Question

The period dimension of the cube that I want to do the rule: short period.png I want to match this period here with the same period of the first cube via rule. How could SUBST help in this case? Thanks a lot. JR. Hi Wim. Sorry about that. I did not put the screenshots here because I tried to do the ...
by Jorge Rachid
Mon Nov 25, 2019 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Question
Replies: 6
Views: 3582

Re: Rule Question

Hi Wim. Sorry about that. I did not put the screenshots here because I tried to do the rule and not worked. I didn't understand how SUBST function would work in this case. I will put the cube structure of the two cubes here so you can help please? This is the first cube with the complete period: cub...
by Jorge Rachid
Mon Nov 25, 2019 1:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Question
Replies: 6
Views: 3582

Rule Question

Hi guys, I need some help. I have two similar cubes and the only difference between then is the period dimension. In one cube I have the complete period, like 11/25/2019, and on another cube I have only month and year, like 11/2019. I am facing some doubt to bring the data from the cube which has co...
by Jorge Rachid
Wed Jul 17, 2019 1:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 31
Views: 19162

Re: Export Cube data in CSV file, with all Months as columns

Hi guys.
I have changed the source view and put all subsets that I don't want on flat file on total.
The other dimensions that I want I put all leaf elements.
On the source view am not skipping consolidated values.
Doing this it worked fine!
Thanks a lot for everyone that helped me.
Best regards.
JR
by Jorge Rachid
Wed Jul 17, 2019 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 31
Views: 19162

Re: Export Cube data in CSV file, with all Months as columns

Hi tomok. So to solve that I have to put only totals on my subsets on source view? Thanks. If you employ the method in this thread you will have to explicitly define subsets for every dimension in the cube you are using as the data source. Since you have to turn off "Skip Consolidated Values&qu...
by Jorge Rachid
Wed Jul 17, 2019 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 31
Views: 19162

Re: Export Cube data in CSV file, with all Months as columns

Hi Wim! The cube in fact has 9 dimension, but on my flat file I only want only some of them. But the other dimensions has only one element for each row of the flat file, so I do not think that is the problem, but I will a export with all dimension to see what happens. Tks. Look at the Prolog tab and...
by Jorge Rachid
Tue Jul 16, 2019 10:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 31
Views: 19162

Re: Export Cube data in CSV file, with all Months as columns

I did that, but now it is coming 16 rows with repeated values. Here my code: vJan = NumberToString(CellGetN('base_despesas_rateio', '01/2019', vEmpresa, vPacote, vArea, vContaOrcamentaria, vGestor, vTipoOrcamento, vTipoDespesa, vMetricas)); vFev = NumberToString(CellGetN('base_despesas_rateio', '02/...
by Jorge Rachid
Tue Jul 16, 2019 8:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 31
Views: 19162

Re: Export Cube data in CSV file, with all Months as columns

Hey guys! I am facing exactly this same problem right now, but I did not understand the flag point. I am using ASCIIOutPut and I want months on columns. I am using the cellgetn to get each month from january from december, but when I use the asciioutput the value of a data point of january for examp...
by Jorge Rachid
Mon Jul 01, 2019 6:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBO Process
Replies: 11
Views: 6026

Re: ODBO Process

Yes, I have. It was with alias, but I have changed and tried again but it still with the same problem.
jim wood wrote: Mon Jul 01, 2019 11:11 am Daft question but do you have a default subset set for the dimension? Does it include the alias?
by Jorge Rachid
Fri Jun 28, 2019 5:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBO Process
Replies: 11
Views: 6026

Re: ODBO Process

Hi Jim, I will post here the mdx generated. WITH SET [periodo_gmd Set] AS '{ FILTER( { [datlan_hst_visao_geral].MEMBERS }, ISLEAF( [datlan_hst_visao_geral].CURRENTMEMBER ) ) }' SET [area_bu Set] AS '{ FILTER( { [area_bu_hst].MEMBERS }, ISLEAF( [area_bu_hst].CURRENTMEMBER ) ) }' SET [pacotes_despesas...