Search found 76 matches

by mnasra
Mon Nov 19, 2018 4:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheet function: find the Group of a user
Replies: 7
Views: 1421

Re: Websheet function: find the Group of a user

You are absolutely right Mark. I only have 5 groups, and I have an if statement in my worksheet which reads each group for my user and tests if it is empty or not. My problem, is the one user who belongs to 2 groups. my if statement stops as soon as I get the group. the 'temporary' solution I found,...
by mnasra
Sun Nov 18, 2018 10:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheet function: find the Group of a user
Replies: 7
Views: 1421

Re: Websheet function: find the Group of a user

ok, i have to be more specific. the websheets checks for which sec group the user belongs to, and applies color scheme. (grey if read, white if write). this works perfectly for all users, except one, because he belongs to 2 different groups. I dont know how to resolve that. it works for him for grou...
by mnasra
Fri Nov 16, 2018 10:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheet function: find the Group of a user
Replies: 7
Views: 1421

Re: Websheet function: find the Group of a user

Thank you Tomok.
So the only way, is to look into the cube and see if the intersection between the user and the group is non empty?
I want to do it in a spreadsheet. it becomes a little cumbersome.
But yes, I can do it this way.

Micheline
by mnasra
Fri Nov 16, 2018 5:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheet function: find the Group of a user
Replies: 7
Views: 1421

Websheet function: find the Group of a user

Hi experts, I need to change the color scheme of the Active Form based on user security. (grey if no access, white if access is permitted) I can find the user (tm1user() function) But the security is per group. How Can I find which group this user belongs to? thanks PS: Maybe I am complicating somet...
by mnasra
Tue Oct 30, 2018 1:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: subnm with variable overriden
Replies: 7
Views: 393

Re: subnm with variable overriden

Thank you all. Yes, this is exactly what I meant. and I am using it on Tm1web. I just realized that I could have said this: I have this command: Subnm (sdim, $E$9 , 1) in E9 I have the name of a subset (that is variable). If the user stays in the subset, it continues to work. But if he chooses anoth...
by mnasra
Tue Oct 30, 2018 3:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: subnm with variable overriden
Replies: 7
Views: 393

Re: subnm with variable overriden

I created a subset of accounts for each cost center. lets say cc200 , i create a subset on the account dim called sub200 ( containing 4 accounts -level 1 in the hierarchy. not deployed to leaf level) the user chooses his cost center (straight subnm command) cc200 the next subnm command, is on the ac...
by mnasra
Mon Oct 29, 2018 7:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: subnm with variable overriden
Replies: 7
Views: 393

subnm with variable overriden

Hi expert, i have a websheet with 2 title headers. 1- What cost center? 2- Depending on the cost center chosen, the subset shows only the accounts (level1) of that cost center (subnm with variable). everything works perfectly. Change the cost center, the list of accounts change too UNTIL ... the use...
by mnasra
Thu Oct 18, 2018 7:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule to find Leaf Level of all dimensions in cube
Replies: 3
Views: 164

Rule to find Leaf Level of all dimensions in cube

Hi Experts,

is there a 1 rule that help find the leaf level of all dimensions in a cube.
I know ELLEV will do each dimension. I can nest the Ifs.
But I am looking for a shortcut. (I have 10 dimensions in the cube).
Thanks.
by mnasra
Fri Feb 09, 2018 8:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: formula for element property in hierarchy
Replies: 4
Views: 932

Re: formula for element property in hierarchy

Thank you very much Wim. I have been doing exactly what you suggested for the last 6 years.
I was wondering if there is something more 'clever' found by the experts.

Micheline
by mnasra
Mon Feb 05, 2018 5:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: formula for element property in hierarchy
Replies: 4
Views: 932

formula for element property in hierarchy

Hi experts, I want to use the same hierarchy of Balance sheet for 2 sets of data with different signs. First set of data, the signs are negative and positive which gives me the balance sheet to zero. (all elements properties are +1) the second set of data, all the amounts are positive, but I need th...
by mnasra
Mon Nov 14, 2016 5:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: FEEDERS issue/Bug
Replies: 4
Views: 1071

FEEDERS issue/Bug

Hi Experts, I was wondering if any of you have encountered this issue: - A cell is not fed anymore (after a restart of the service) - Check the cell - NOT FED - Check the Feeding cell using TRACE. It says that my above cell is FED Have to Trick TM1, add a bogus line in the feeders portion of the Rul...
by mnasra
Thu Jun 30, 2016 7:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleted calculated element in measure still showing
Replies: 1
Views: 409

Deleted calculated element in measure still showing

Hello experts, I have the weirdest 'bug' i have ever seen with my 6 years with TM1. I had an element in a measure that I calculated via rule. I changed the element name, I change the rules and I deleted the element. I opened an old 'perspectives' report where this element is still mentioned. I would...
by mnasra
Tue Sep 15, 2015 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: pass values between Websheets in TM1 Application
Replies: 2
Views: 672

Re: pass values between Websheets in TM1 Application

Sorry Lotsaram, but I am still struggling with this issue. I might be writing too much in the subnm or too little. But it is not working. I have 5 websheets that I put in a tm1 application (responsibility). In the all the websheets, the user has to enter which supplier he wants to see details. IN ea...
by mnasra
Mon Aug 24, 2015 10:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: pass values between Websheets in TM1 Application
Replies: 2
Views: 672

pass values between Websheets in TM1 Application

Hello Experts, I think it is too simple, but I cannot see it. I need to create a tm1 application with 5 different websheets each containing more than 1 sheet. The user will enter his choice of which supplier he wants to see in the first websheet, and I need to pass this information between websheets...
by mnasra
Wed Jun 17, 2015 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process does not pick non fed leaf level cells
Replies: 3
Views: 1199

Re: TI process does not pick non fed leaf level cells

Thank you so much both Declan and David. Yes Declan I had the rules to be picked up, but it was not doing it.
But I will definitely take David's idea of a hierarchy.
Thank you so much
by mnasra
Wed Jun 17, 2015 1:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process does not pick non fed leaf level cells
Replies: 3
Views: 1199

TI process does not pick non fed leaf level cells

Hi Experts, I have a measure C = A - B (A is static during the day) B is where Users enter their numbers C is used ONLY to capture where the user has changes during the day. ( I don't need C to be fed) I created a TI process that reads C to update A (when needed). The TI does not EXTRACT non fed lea...
by mnasra
Fri Jan 23, 2015 3:16 pm
Forum: Enhancements
Topic: Multi Thread Rules Saving
Replies: 1
Views: 1898

Multi Thread Rules Saving

Hi Experts, I searched the forum for this topic, I found a lot of multi-treaded questions/answers but I did not find what I am looking for. I dont know if it exists or not. So before putting it as a suggestion here it is: I have mtq using multithreads when I query (perfect) I have maximumcubeload fo...
by mnasra
Thu Jan 15, 2015 11:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Simulation of Array variable types in TI
Replies: 18
Views: 7034

Re: Simulation of Array variable types in TI

Thank you very much. It was the left hand side. I will create a cube for that.
;) ;)
by mnasra
Wed Jan 14, 2015 7:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Simulation of Array variable types in TI
Replies: 18
Views: 7034

Re: Simulation of Array variable types in TI

yes, it is 2015- Yes, I have the same problem. I tried to open the document mentioned above, but it is not there anymore. Do anyone knows in 2015 how to created array variables in TI and give these variables a value. In other terms I want to say (in as few lines as possible). var(1) = Index Var(2) =...
by mnasra
Fri Dec 19, 2014 6:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Customize
Replies: 4
Views: 2282

Re: Drill Customize - RESOLVED

Sorry for the miunderstanding.
I finally figured it out. I dont know if it is the best way but here is what I did:
1- I created a subset inside the Period dimension
2- I put the period (as part of the view)
3- I change the elements in the view in the prolog.

Thanks