Search found 128 matches
- Thu Jul 26, 2018 7:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: mdx returning incorrect results
- Replies: 1
- Views: 1674
mdx returning incorrect results
Hi I am using below mdx to get a list of customers whose grade is D and and type is not 'DST1' from region 1 {Filter({TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER({[Customers SoldTo Only].[All Regions].[Region - 001]}, ALL, RECURSIVE )}, 0)},([AR HISTORY].([AR Measures].[Letter Grade],TM1Member( [Months].[...
- Thu May 10, 2018 2:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Server Locked after save data process and save data is running for a long time .
- Replies: 15
- Views: 14839
TM1 Save Data Issue 2.0.4
Hi , We recently upgraded from 10.1 to planning analytics 2.0.4 . We have an issue where save data is taking a long time to run only in the afternoon and locks up all users . Save data is scheduled to run every 6 hours . We have confirmed that there is no virus scan being run on the system during th...
- Wed May 09, 2018 9:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: stored values in tm1
- Replies: 6
- Views: 4611
Re: stored values in tm1
Should I use roundp while storing the values.
How are others overcoming this issue . do you always write roundp when there is a decimal value stored .
How are others overcoming this issue . do you always write roundp when there is a decimal value stored .
- Wed May 09, 2018 7:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: stored values in tm1
- Replies: 6
- Views: 4611
stored values in tm1
Hi, I am having some issues with zero out not happening for few rows , when analysed deeply , I have a cost sets cube where I load cost for material for specific time . so I load 86.29 and the measure has format as comma with 2 decimals . But the number is shown as 86.29 .But when right clicked and ...
- Fri May 04, 2018 3:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Passing values in TI for sql query
- Replies: 4
- Views: 4440
Re: Passing values in TI for sql query
Thanks for the reply ,but that doesnt help still gettign sql failed error when used below synatax. where [Month] in ('Pm1'); where Pm1 = '201805'; My column in sql table is numeric and has values like 201805 SO in my ti if i hardcore as where month in ('201805','201806') it works . Which I assume is...
- Fri May 04, 2018 12:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Passing values in TI for sql query
- Replies: 4
- Views: 4440
Passing values in TI for sql query
Hi , I have a ti process which connects to a sql server and have the query in ti . I need to pass the current month, Last 2 months in TI as input in where clause. I can hardcode like where period in ('201805','201804',201803'); The period is defined as numeric datatype in sql . How can I pass my TI ...
- Mon Apr 23, 2018 9:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Server Locked after save data process and save data is running for a long time .
- Replies: 15
- Views: 14839
Server Locked after save data process and save data is running for a long time .
Hi , We recently upgraded from 10.1 to planning analytics 2.0.4 . We have an issue where save data is taking a long time to run only in the afternoon and locks up all users . Save data is scheduled to run every 6 hours . We have confirmed that there is no virus scan being run on the system during th...
- Tue Feb 20, 2018 4:02 pm
- Forum: Useful code, tips and tricks
- Topic: Using old clients with new planning analytics server
- Replies: 16
- Views: 57157
Re: Using old clients with new planning analytics server
we see the server on double clicking on the server nothing happens, Will not show me the login credentials to enter or log me in through integrated login . But it works with the new client .
I alos have additional parameter IPAddress= T
SupportPreTLSv12Clients=T
in the config files.
I alos have additional parameter IPAddress= T
SupportPreTLSv12Clients=T
in the config files.
- Tue Feb 20, 2018 3:23 pm
- Forum: Useful code, tips and tricks
- Topic: Using old clients with new planning analytics server
- Replies: 16
- Views: 57157
Re: Using old clients with new planning analytics server
Yes we want architecture to connect . We are in 10.1 and trying to connect to IBM Planning Analytics .
I have added the entry in the config file
SupportPreTLSv12Clients=T and restarted the server .
But the server shows up but we could not login to it .
I have added the entry in the config file
SupportPreTLSv12Clients=T and restarted the server .
But the server shows up but we could not login to it .
- Tue Feb 20, 2018 1:52 pm
- Forum: Useful code, tips and tricks
- Topic: Using old clients with new planning analytics server
- Replies: 16
- Views: 57157
Using old clients with new planning analytics server
Hi we are having client 10.1 and planning to connect with new planning analytics server . is this compatible and possible to use the old client with the new server . If anyone has achieved this please let us know . Thanks, Admin : see the linked post in this thread for the important post in this thr...
- Mon Feb 19, 2018 9:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules Passing children
- Replies: 8
- Views: 6528
Re: Rules Passing children
Any suggestion on this is appreciated.
Can you think of any other way to get the childrens .
If I use ELcomp it gives only one children. I need to pass all children.
COnsolidatechildren('Customers') worked but not sure that would affect performance.
Any other suggestions is appreciated
Can you think of any other way to get the childrens .
If I use ELcomp it gives only one children. I need to pass all children.
COnsolidatechildren('Customers') worked but not sure that would affect performance.
Any other suggestions is appreciated
- Mon Feb 19, 2018 3:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules Passing children
- Replies: 8
- Views: 6528
Re: Rules Passing children
Hi I need to pass my childrens of the customer in the rule statement . I was thinking some thing like ELCOMP etc.. I have this already working , if(Attrs('CUstomer',!Customer, 'Pass Children')=True, DB('Sales',Children(!Customer)), DB('Sales',!Customer). I need the equivalent expression to get the c...
- Mon Feb 19, 2018 1:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules Passing children
- Replies: 8
- Views: 6528
Re: Rules Passing children
Based on attribute value , I I have to pass all the childrens for a selected customer for a certain case and customer itself in certain cases .
DB('Sales',!Customer)
or
DB('Sales',Childrens(!Customer))
I am not sure for the syntax to pass all CHildrens(!Customer).
Thanks
DB('Sales',!Customer)
or
DB('Sales',Childrens(!Customer))
I am not sure for the syntax to pass all CHildrens(!Customer).
Thanks
- Sat Feb 17, 2018 4:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules Passing children
- Replies: 8
- Views: 6528
Rules Passing children
Based on certain condition I need to pass the childrens of a element in a rule .
Like
DB('Sales',!Customer)
I have to pass all childrens of selected customer .
Whats the function or syntax I can use to achieve this .
Thanks , any help is appreciated.
Like
DB('Sales',!Customer)
I have to pass all childrens of selected customer .
Whats the function or syntax I can use to achieve this .
Thanks , any help is appreciated.
- Fri Feb 16, 2018 9:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Issue with Pulling data from Sales Cube for AR Cube
- Replies: 3
- Views: 3254
Re: Issue with Pulling data from Sales Cube for AR Cube
Okay thanks , I will use Attributes and how doI pass the elements all children in the rule .
DB('Sales',!Customers,!months,'Full Revenue');
If Attribute value is true then I need to pass all the children of the selected customer .
DB('Sales',!Customers,!months,'Full Revenue');
If Attribute value is true then I need to pass all the children of the selected customer .
- Fri Feb 16, 2018 2:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Issue with Pulling data from Sales Cube for AR Cube
- Replies: 3
- Views: 3254
Re: Issue with Pulling data from Sales Cube for AR Cube
Now I cannot use ELPAR in my rule to pass the value based on condition since i have multiple Hierarchies .
- Fri Feb 16, 2018 2:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Issue with Pulling data from Sales Cube for AR Cube
- Replies: 3
- Views: 3254
Issue with Pulling data from Sales Cube for AR Cube
Hi , I have an AR cube which has a customers dimension like All Region -> Region -> Agency->Rep-> Customers . Now there is a rule in the cube which takes the customer element and pulls data from sales cube . Now there was a requirement to see customers by collection specialist , so I created an alte...
- Thu Feb 15, 2018 7:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX on string filter gives different results
- Replies: 1
- Views: 1923
Re: MDX on string filter gives different results
do i need to specify all elements in the cube in the filter . {Filter({TM1FILTERBYLEVEL(DESCENDANTS([Customers SoldTo Only].[Region - 004 - EVOLUTION - EVOL519]) , 0)},[AR History].([AR Measures].[Total Finance View],[Currency].[Local Currency],[GL Accounts].[ASSETS],TM1Member( [Months].[Cognos Curr...
- Thu Feb 15, 2018 5:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX on string filter gives different results
- Replies: 1
- Views: 1923
MDX on string filter gives different results
Hi , I have an issue and I am trying to use the below mdx and its giving correct result only for letter grade 'InActive' for all others grades like 'A' to 'F' it gives wrong results . Even if the grade is 'C' it brings the customer when filtered as ' A'. MDX : vmdxFAccountCount='Filter(TM1FILTERBYLE...
- Wed Feb 14, 2018 8:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Issue
- Replies: 4
- Views: 3178
Re: MDX Issue
Can I have a Count surrounding the above expression .