Search found 122 matches

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: 4
Views: 303

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: 10
Views: 1000

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: 10
Views: 1000

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: 10
Views: 1000

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

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

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

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

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

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

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

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

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

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

Re: MDX Issue

Can I have a Count surrounding the above expression .
by Analytics123
Wed Feb 14, 2018 6:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Issue
Replies: 4
Views: 303

Re: MDX Issue

Also I tried this with just one dimension on filter condition . {Count(Filter({TM1FILTERBYLEVEL({DESCENDANTS([Customers SoldTo Only].[Region - 001 - CROSSROADS - CROSS040]) }, 0)},([AR History].[AR Measures].[Recent Activity]])=0))} But does count makes logical to have here ? Will it give the count ...
by Analytics123
Wed Feb 14, 2018 6:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Issue
Replies: 4
Views: 303

MDX Issue

Hi , I am using the below mdx on an insert subset to test the results . {Filter({TM1FILTERBYLEVEL({DESCENDANTS([Customers SoldTo Only].[Region - 001]) }, 0)},([AR History].[AR Measures].[Recent Activity],[AR History].[Months].[Feb 2018])=0)} I want to check the value of Recent activity for all the n...
by Analytics123
Wed Feb 14, 2018 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count the number of children and store it as an attribute for the parent
Replies: 5
Views: 410

Re: Count the number of children and store it as an attribute for the parent

Thanks for the suggestions. I cannot spread 1 as I will also have to do some conditional check to see if the customer is active based on another measure.
by Analytics123
Wed Feb 14, 2018 3:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count the number of children and store it as an attribute for the parent
Replies: 5
Views: 410

Count the number of children and store it as an attribute for the parent

Hi, I have a cube with customer dimension which has an hierarchy like Region ->Agency - > Rep-> Customer Now the cube has measures based on the customer loaded like recent activity , balances, sales etc . Users wants to know the count of number of customers for each region and each agency . Now I pl...
by Analytics123
Thu Jan 18, 2018 8:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: add part of dimension to a new dimension
Replies: 5
Views: 509

Re: add part of dimension to a new dimension

this code doesn't work if I have more than 1 child .

Example

Car-> camry->level1 ->s4

iterate all n level , we get s4 ,

now only s4 and its parent level 1 is copied to the new dimension . I still wanted camry and car .
by Analytics123
Thu Jan 18, 2018 1:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: add part of dimension to a new dimension
Replies: 5
Views: 509

add part of dimension to a new dimension

Hi, I have a dimension say car which has elements with parent ,child relation with different levels. car-> Toyota->SE,LE,XE Hundai->Model1->XSE now I need to copy all these elements to another dimension say 4 wheelers with a parent child relation in car I will create a subset of all N level in car d...