Search found 103 matches

by mnasra
Mon Jun 22, 2020 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple COA Best Practice
Replies: 6
Views: 234

Re: Multiple COA Best Practice

Perfect. that confirms what I thought. And yes, obviously, it will be 1 set per ERP (which can have more than 1 entity). I inherited this account from another consultant, who tried 1 COA for all (because it is easier to report I guess). But here I am, and he is not. That says it. Thanks again for yo...
by mnasra
Mon Jun 22, 2020 2:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple COA Best Practice
Replies: 6
Views: 234

Multiple COA Best Practice

Hi Experts, I need your advice. I have a customer that have multiple companies, multiple Chart of accounts. They do have Controller for the Consolidations. We need to budget by Company /COA in TM1. My question: Do I create 1 dimension that contains all Chart of accounts in different hierarchies? Mea...
by mnasra
Mon Jun 08, 2020 5:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Flow Controller and TM1 (ACTUALS)
Replies: 2
Views: 333

Re: Data Flow Controller and TM1 (ACTUALS)

Oh WOW. THANK YOU So much Lotsaram. (oddly, I did not receive an email to tell me that you posted something). I think, based on your answer I am going to explore both options (2-3) and decide if I want the same option for Metadata and data. I inherited at my client site, is option 1. The customer wa...
by mnasra
Thu May 28, 2020 8:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Flow Controller and TM1 (ACTUALS)
Replies: 2
Views: 333

Data Flow Controller and TM1 (ACTUALS)

Hi Expert, I searched the Forum and Could not find a 'new' answer to my question. SORRY for the inconvenient. I need to know what is the best way to have Controller and Tm1 cohabit for ACTUALS Do I load every COA by Company In TM1 or in Controller First. The Mapping between the Conso accounts and th...
by mnasra
Thu Apr 30, 2020 3:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SANDBOX commit specific data
Replies: 2
Views: 544

Re: SANDBOX commit specific data

Oh wow. Thanks. Never thought of the logging enablement.
I 'resolved' the problem by asking the user to download to excel the data he wants to keep and loading it using TI.
Why make it simple when you can complicated it.
But THANKS, I will look into the logging thing.

micheline
by mnasra
Mon Apr 27, 2020 2:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SANDBOX commit specific data
Replies: 2
Views: 544

SANDBOX commit specific data

Hi expert, Is there a way to commit specific data from a Sandbox. OR, revert specific data to the base. Here is what happened: user made a lot of changes in his sandbox. one of the changes made very early is not good. he needs to bring it back to base, Or commit everything else except this one. I ca...
by mnasra
Thu Apr 09, 2020 6:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetCreate by MDX
Replies: 2
Views: 247

Re: SubsetCreate by MDX

SOLVED! Thank you so much. I had never seen the subsetMdxSet.
Stay safe.
by mnasra
Thu Apr 09, 2020 3:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetCreate by MDX
Replies: 2
Views: 247

SubsetCreate by MDX

Hi expert. I created a subset in a TI process by mdx all recursive. It works beautifully. And I used it in views. I need to update it regularly. So, I had to write a subset destroy just before the subsetcreate in the TI. It does not want to destroy because it is used in a view. What is the solution?...
by mnasra
Thu Apr 09, 2020 3:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Widget Selector Alias
Replies: 4
Views: 288

Re: PAW Widget Selector Alias

Ah…. That's it. Adding the selector from a subset instead of from the dimension itself.
I knew it had to be something simple.
Thank you. Very appreciated.
Stay Safe
by mnasra
Thu Apr 09, 2020 2:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Widget Selector Alias
Replies: 4
Views: 288

Re: PAW Widget Selector Alias

Thanks. But for some reason the little pencil does only 1 thing: edit the title. Am I missing somethin so obvious I could not see it.
by mnasra
Wed Apr 08, 2020 6:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Widget Selector Alias
Replies: 4
Views: 288

PAW Widget Selector Alias

Hi all,

This is a very basic question, but I cannot find the answer.
I just added a widget selector to a PAW view. I need to show the Alias and not the principal name.
I cannot find where.. Sorry, I am sure the answer is obvious, but cannot find it.
Thanks
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: 1957

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

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

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

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

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

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

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

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

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.