Search found 92 matches

by mnasra
Wed Nov 06, 2019 3:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: download to excel from Sql drill through
Replies: 0
Views: 272

download to excel from Sql drill through

Hi Experts, I have a strange error. I have a drill through process that goes down to a relational database 'ugly' SQL query screen. One of the columns is the Invoice Reference that is alpha numeric. When I download to Excel (Snapshot) - If the reference has any ALPHA caracter it downloads it perfect...
by mnasra
Mon Aug 12, 2019 10:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Workspace BOOK
Replies: 4
Views: 1727

Re: Copy Workspace BOOK

Hi Experts, I had posted this thread and received very good information about copying my workspace. I indeed copy a backup and I have files with .gz extensions. Now I need to 'restore' one of my backups into a different environment. I can see there is something called import. It says: Imported. But ...
by mnasra
Thu Aug 08, 2019 6:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: websheet function equivalent to cellisupdatable
Replies: 2
Views: 759

Re: websheet function equivalent to cellisupdatable

Thanks Jim.
Yes, some fields are by rules, some are by security in the control cube, and
Some are by security at the dimension level (like Actuals are read only)

I tried to put a flag, but I have many user types. way too many flags!
Thanks for trying. I hoped the problem was already solved!
by mnasra
Thu Aug 08, 2019 5:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: websheet function equivalent to cellisupdatable
Replies: 2
Views: 759

websheet function equivalent to cellisupdatable

Hi Expert,

I need to color differently the cells in a websheet depending if the cell is updatable or not.
I wish I can write a websheet command to find the STATUS of the cell (same logic as write clicking on it- Edit Status, which gives me cell is editable or not).

Thank you
micheline
by mnasra
Fri Jul 26, 2019 6:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Workspace Conditional Formatting Leaf level
Replies: 2
Views: 705

Re: PA Workspace Conditional Formatting Leaf level

I am not horrified. I am impressed.
It works for me.

thank you Rodger,
by mnasra
Fri Jul 19, 2019 6:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Workspace Conditional Formatting Leaf level
Replies: 2
Views: 705

PA Workspace Conditional Formatting Leaf level

Hi Experts, Do you have a trick how to do conditionnal formatting in Workspace, but only to the leaf levels. I have a view with number of hours per employee and the employees are grouped by department, and VP etc. I want to implement a conditional formatting at the employee level (and not department...
by mnasra
Tue Jul 16, 2019 1:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Button does not give RUN Process option
Replies: 5
Views: 596

Re: PAW Button does not give RUN Process option

THANK You all. YES, you are right. I am at version 36. Did not even occur to me to compare versions.
Thank you again.
by mnasra
Mon Jul 15, 2019 10:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Button does not give RUN Process option
Replies: 5
Views: 596

PAW Button does not give RUN Process option

Hi Experts,
I need to add a button in PAW to give the user the ability to run a process.
I saw it on IBM Cloud.
But I cannot see it in my environment and I am a Workspace and Tm1 administrator.
thanks
by mnasra
Wed Jul 10, 2019 7:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Cannot see the dimension or processes
Replies: 3
Views: 509

Re: PAW Cannot see the dimension or processes

Thank you very much Declanr.
yes you are right, I dont seem to be the administrator of Workspace.
by mnasra
Tue Jul 09, 2019 8:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Cannot see the dimension or processes
Replies: 3
Views: 509

PAW Cannot see the dimension or processes

Hi Expert, I have a problem with the installation (or parameters) of the Planning Analytics Workspace. Under the database menu , I only can see the applications and cubes. I cannot see the dimensions nor the processes. I am definitely connected as an Admin. I can go down to the dimension of a cube a...
by mnasra
Wed Jun 26, 2019 7:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Workspace BOOK
Replies: 4
Views: 1727

Re: Copy Workspace BOOK

Thank you very much Roger.
Yes, this works.
And ... how come IBM did not tell me that????
by mnasra
Fri Jun 21, 2019 7:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Workspace BOOK
Replies: 4
Views: 1727

Copy Workspace BOOK

Hi Expert, I created a Workspace book in a TM1 instance. I need to copy the book (definition) into a new instance. I obviously can copy, Pax reports, Excel, Views etc.. But not the definition of the Book. I asked IBM and ..... they referred me to any blog I was part of....?? I am hoping someone has ...
by mnasra
Tue Jun 18, 2019 9:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheet Refresh Button in WORKSPACE
Replies: 6
Views: 819

Re: Websheet Refresh Button in WORKSPACE

GOT IT. Sorry, I was still trying to use my old button.
I created a new one with PAX and it worked fine.
THANK YOU Very much all
by mnasra
Tue Jun 18, 2019 9:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheet Refresh Button in WORKSPACE
Replies: 6
Views: 819

Re: Websheet Refresh Button in WORKSPACE

Thank you Wim. I just changed it. But I am a consultant, so I have customers with different versions. And actually, My problem right now, is on the IBM Cloud BLUE. (formely cloud concierge). I just ran the utility for the action button. I also wrote a completely new report with PAX. I cannot make th...
by mnasra
Tue Jun 18, 2019 8:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheet Refresh Button in WORKSPACE
Replies: 6
Views: 819

Re: Websheet Refresh Button in WORKSPACE

Oh wow. Thank you all. Yes I built it in Perspectives. And no, I did not even know about the utility. I am looking into it. Thanks again
by mnasra
Wed Jun 12, 2019 7:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheet Refresh Button in WORKSPACE
Replies: 6
Views: 819

Websheet Refresh Button in WORKSPACE

Hi Expert, I have an active Form with a Rebuild Sheet Button. When I added the websheet in Workspace the Button does not work. I know that I can find the Rebuild Sheet icon in the toolbar, but my users dont want that. They prefer a very visible Button on the websheet. I tried the Button function, bu...
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: 2001

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

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

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

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...