Search found 128 matches

by Analytics123
Thu Jul 26, 2018 7:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: mdx returning incorrect results
Replies: 1
Views: 1624

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].[...
by Analytics123
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: 14286

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...
by Analytics123
Wed May 09, 2018 9:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: stored values in tm1
Replies: 6
Views: 4468

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 .
by Analytics123
Wed May 09, 2018 7:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: stored values in tm1
Replies: 6
Views: 4468

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 ...
by Analytics123
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: 4312

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...
by Analytics123
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: 4312

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 ...
by Analytics123
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: 14286

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...
by Analytics123
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: 53539

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.
by Analytics123
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: 53539

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 .
by Analytics123
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: 53539

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...
by Analytics123
Mon Feb 19, 2018 9:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Passing children
Replies: 8
Views: 5981

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
by Analytics123
Mon Feb 19, 2018 3:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Passing children
Replies: 8
Views: 5981

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...
by Analytics123
Mon Feb 19, 2018 1:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Passing children
Replies: 8
Views: 5981

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
by Analytics123
Sat Feb 17, 2018 4:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Passing children
Replies: 8
Views: 5981

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.
by Analytics123
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: 2982

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 .
by Analytics123
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: 2982

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 .
by Analytics123
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: 2982

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...
by Analytics123
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: 1728

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...
by Analytics123
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: 1728

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...
by Analytics123
Wed Feb 14, 2018 8:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Issue
Replies: 4
Views: 2926

Re: MDX Issue

Can I have a Count surrounding the above expression .