Search found 121 matches

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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...
by Analytics123
Mon Jan 15, 2018 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Not Fed
Replies: 11
Views: 702

Re: Feeders Not Fed

Okay its working now . Thanks for your help on this and putting so much time to explain . I am still confused with logic and will take simple example . Only tow days of sale Sale CumSale 1 100 100 2 50 50 1 MTD - 1 and 2 MTD - 2 ,1 So rule [CumSale]= DB ('Trend',!Day|'MTD', 'Sale'); so for feeder he...