TM1 Forum

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

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

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.

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

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

Thank you all.

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

Kenneth

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

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

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

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

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

Kenneth

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?

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

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

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

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.

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

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

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.

Thanks. Will try! Kenneth Try to use this before CubeRuleDestroy(CubeName); and CubeRuleAppend(CubeName, RuleText, IsCalculationRule); after update dimension with alias Or create config cube to stet alias rules on time wheen you update dimensionn example: [aliasNameElement] s:= IF( DB(configcube, 'U...