Search found 95 matches

by kenship
Tue May 15, 2018 2:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset with Expand Above
Replies: 3
Views: 156

Re: Dynamic Subset with Expand Above

Thanks for the reply. For now my solution is break the relationship of the "(Net Profit)" by skipping a level in Gross Expenditures and Revenues. In doing so the dynamic subset reads each rollup separately and allow me to insert "(Net Profit)" as a separately item instead of it being related in the ...
by kenship
Tue May 15, 2018 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset with Expand Above
Replies: 3
Views: 156

Dynamic Subset with Expand Above

Hi, I'm working on a dynamic subset and couldn't figure out what's wrong. I have a P&L dimension. (Net Profit) > Revenue > Gross Exp Now there's a special request in that they want to see: (Net Profit) > Revenue item 1 > Revenue item 2 ... > Revenue > Gross Exp item 1 > Gross Exp item 2 ... > Gross ...
by kenship
Fri Apr 06, 2018 2:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running PA objects in 10.2
Replies: 4
Views: 321

Re: Running PA objects in 10.2

Thanks for the information. I'll have to check the version of PA and note this issue. Answer is no unless it is the latest version of 10.2.2 FP7 plus fix packs. There was a recent IF to 10.2.2 FP7 which correlated to a IF of PA 2.0.2 or 2.0.3 which introduced a change to format of cube files. If you...
by kenship
Fri Apr 06, 2018 1:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running PA objects in 10.2
Replies: 4
Views: 321

Re: Running PA objects in 10.2

Truth is we haven't tested it yet. We just want to gather intel from other then plan based on the knowledge.

Thanks!
tomok wrote:
Fri Apr 06, 2018 1:21 pm
I think as long as you have not used any of the new features of PA then the answer would be yes. Have you tried? I would do that before I would take anyone's word for it.
by kenship
Fri Apr 06, 2018 12:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running PA objects in 10.2
Replies: 4
Views: 321

Running PA objects in 10.2

Hi,

Can cubes, dimensions, rules, TI etc. developed in PA be copied straightly and run in 10.2 w/o any modification?

I believe running 10.2 objects in PA is OK. Not sure the otherwise.

Thanks.

Kenneth
by kenship
Thu Mar 15, 2018 2:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Improve TI Processing Time
Replies: 8
Views: 777

Re: Improve TI Processing Time

MDX is used as data source, but cells being written is not used for rules nor feeders. Also tried using external file, doesn't really help. I will stop worrying about this for now. Thanks. Kenneth Are you writing values to cells that are used as sources (on the LHS) for feeders? If so, it can be slo...
by kenship
Tue Mar 13, 2018 5:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Improve TI Processing Time
Replies: 8
Views: 777

Re: Improve TI Processing Time

Thank you all.

I'll try to experiment with exporting data then importing it.

Kenneth
by kenship
Mon Mar 12, 2018 5:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Improve TI Processing Time
Replies: 8
Views: 777

Improve TI Processing Time

Hi, I'm trying to find some idea on how to improve TI processing time. I have a process that transfer salary budget data cube into operating budget cube. Summarized salary data is mapped to operating budget cube based on gl accounts. The process consists of: Prolog - setting up variables, create sou...
by kenship
Thu Mar 01, 2018 6:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Crash Due To Page File
Replies: 8
Views: 577

Re: Server Crash Due To Page File

We have one daily process. It ran about 9 hours before crash, didn't notice any error message. What I meant by loading means running TI to load csv file for building dimension. What I meant to say was we were not doing anything out of ordinary for the last few years. Right now I'm monitoring the fre...
by kenship
Thu Mar 01, 2018 6:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Crash Due To Page File
Replies: 8
Views: 577

Re: Server Crash Due To Page File

Here's the interesting thing, we haven't loaded or modified any new dimension, cube, hierarchy whatsoever. When the memory from server stat reached 98G, my cube stat totals 6G only, which gives me no clue of which cube is giving me issue. Kenneth Have you by any chance got any CA reports looking at ...
by kenship
Thu Mar 01, 2018 3:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Crash Due To Page File
Replies: 8
Views: 577

Server Crash Due To Page File

One of our instance has been crashing 3 times for the last 2 days. The immediate reason is that there was no more free disk space for read and write of temporary files. At worst only 80k was available before crash. We have a small model and here's what I know about our setup: Total memory = 32GB Tot...
by kenship
Thu Mar 01, 2018 1:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button Caption Text Disappears When Scrolling Mouse
Replies: 4
Views: 387

Re: Action Button Caption Text Disappears When Scrolling Mouse

I start noticing that this ONLY happens in 2013 Excel, 2010 Excel has no issue at all.

Kenneth
by kenship
Tue Feb 27, 2018 2:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button Caption Text Disappears When Scrolling Mouse
Replies: 4
Views: 387

Re: Action Button Caption Text Disappears When Scrolling Mouse

My apology for not mentioning it.

It's in Excel.
tm123 wrote:
Tue Feb 27, 2018 2:22 pm
Is this happening in Excel or TM1Web?
by kenship
Tue Feb 27, 2018 2:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button Caption Text Disappears When Scrolling Mouse
Replies: 4
Views: 387

Action Button Caption Text Disappears When Scrolling Mouse

Hi, I have this odd behavior in an Active Form. I inserted an Action Button to rebuild the sheet and put caption in the button. When I wheel scroll my mouse while hovering on that button the following happens: 1. Caption will disappear 2. Cursor changes to the big plus "+" which allows cell to be ed...
by kenship
Wed Feb 14, 2018 2:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX in TI to include additional group of the same dimension
Replies: 7
Views: 458

Re: MDX in TI to include additional group of the same dimension

Thanks for the explanation! It works, Thanks! May I ask when curly bracket is needed? Kenneth When the MDX function/property returns a member, not a set, the curly bracket defines it as a set. In your case with the TM1drilldownmember, it operates on each member of a set, so it requires a set definit...
by kenship
Tue Feb 13, 2018 6:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX in TI to include additional group of the same dimension
Replies: 7
Views: 458

Re: MDX in TI to include additional group of the same dimension

It works, Thanks! May I ask when curly bracket is needed? Kenneth sMDX = '{TM1FILTERBYLEVEL( TM1DRILLDOWNMEMBER (TM1DRILLDOWNMEMBER {[' | vDimName | '].[(PROPOSED BUDGET)]},{[' | vDimName | '].[(RESTATED BUDGET)]}, ALL, RECURSIVE), 0)}'; .. Think you were almost there, just duplicated the TM1DRILLDO...
by kenship
Tue Feb 13, 2018 6:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX in TI to include additional group of the same dimension
Replies: 7
Views: 458

Re: MDX in TI to include additional group of the same dimension

Read about it then forgot.

Thanks a lot! Will try.

Kenneth
tomok wrote:
Tue Feb 13, 2018 4:45 pm
The MDX function is UNION. You want to UNION your two results together.
by kenship
Tue Feb 13, 2018 2:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX in TI to include additional group of the same dimension
Replies: 7
Views: 458

MDX in TI to include additional group of the same dimension

Hi, By help I received here certain months ago I have the following MDX statement to drill down and filter to include only level 0 elements of a certain group in a dimension. It looks like this: sMDX = '{TM1FILTERBYLEVEL( TM1DRILLDOWNMEMBER( {[' | vDimName | '].[(PROPOSED BUDGET)]}, ALL, RECURSIVE),...
by kenship
Wed Feb 07, 2018 3:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }ElementAttributes Rule and TI conflict
Replies: 10
Views: 624

Re: }ElementAttributes Rule and TI conflict

Yes and exactly what I'm thinking.

Thanks to all!
holger_b wrote:
Wed Feb 07, 2018 3:04 pm
RuleLoadFromFile(Cube, TextFile) could be even quicker if it is just about reinstating the previously deleted rules
by kenship
Wed Feb 07, 2018 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }ElementAttributes Rule and TI conflict
Replies: 10
Views: 624

Re: }ElementAttributes Rule and TI conflict

Noted. I'll back up and test the Rule append function to make sure.
Drg wrote:
Wed Feb 07, 2018 2:23 pm
I ask you to take into account that CubeRuleDestroy permanently deletes the file. for correct operation, before you perform this function, you must first copy the }elementattribute*.rux file to a temporary folder.
;)