Hi Wim, yes I know.
I hope that I can get used to it.
I will try the workspace.
Thanks
JR
Search found 113 matches
- Sun Jan 05, 2020 5:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advanced Rules Editor on PA
- Replies: 7
- Views: 3890
- Sat Jan 04, 2020 8:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advanced Rules Editor on PA
- Replies: 7
- Views: 3890
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...
- Sat Jan 04, 2020 8:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advanced Rules Editor on PA
- Replies: 7
- Views: 3890
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...
- Sat Jan 04, 2020 8:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advanced Rules Editor on PA
- Replies: 7
- Views: 3890
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...
- Mon Dec 30, 2019 7:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advanced Rules Editor on PA
- Replies: 7
- Views: 3890
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 ...
- Thu Dec 12, 2019 8:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Region Problem After PA Migration
- Replies: 7
- Views: 3985
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...
- Wed Dec 11, 2019 12:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Region Problem After PA Migration
- Replies: 7
- Views: 3985
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 ...
- Wed Dec 11, 2019 11:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Region Problem After PA Migration
- Replies: 7
- Views: 3985
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...
- Tue Dec 10, 2019 8:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Region Problem After PA Migration
- Replies: 7
- Views: 3985
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...
- Mon Nov 25, 2019 2:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Question
- Replies: 6
- Views: 3650
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...
- Mon Nov 25, 2019 2:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Question
- Replies: 6
- Views: 3650
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 ...
- Mon Nov 25, 2019 2:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Question
- Replies: 6
- Views: 3650
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...
- Mon Nov 25, 2019 1:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Question
- Replies: 6
- Views: 3650
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...
- 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: 19418
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
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
- 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: 19418
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...
- 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: 19418
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...
- 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: 19418
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/...
- 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: 19418
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...
- Mon Jul 01, 2019 6:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBO Process
- Replies: 11
- Views: 6112
- Fri Jun 28, 2019 5:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBO Process
- Replies: 11
- Views: 6112
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...