TM1 Forum

Thank you all for the insight! My main concern here was dealing with users that can easily make a mistake when multiple dimensions are involved. The customer wants "ONE BIG CUBE SO I CAN SEE EVERYTHING". They don't understand that in perspectives (as baby tiger referenced) you can referenc...

Thanks babytiger,

I am more concerned about the users over performance and not to mention the DBRW formulas wouldn't be as friendly with a smaller footprint. Also I agree that the rules could become complex if balance sheet and Income statement are combined.

Thank you for your input!

Hello All, I would like your input on the design of a Financial Cube Model. We switched out our GL source to MS AX and am debating on splitting the GL source into 4 separate cubes: Gross Margin, BS, SG&A, and Marketing or lumping everything into one cube. The big question is weather to build one...

Excellent!

Wim, Glad to be of service. And yes... I know that YOU don't need a TI wizard. ;) One more thing to mention... If you are going to only use the prolog and epilog, It is worthy to mention to set your datasource like so (at least in the Java API): aProcess.setProperty(TM1Properties.ProcessDataSourceTy...

I found one of my methods in Java that creates a Parameter... private void setProcessParameters(String parameterName) { /** If the Parameter is set to ALL, then the process will export the entire cube**/ if(!parameterName.equals(measureName)) { parameterName = "ALL"; } TM1Val propArr1 = TM...

Wim, In the Java API you can set the properties of the variables. I am sure you can do it in the VP API. The first thing you do is create TM1Val's for the Names, Types, UIData, and Positions of the Variables. If the Variable is a String you want to add the TM1ObjectType.VariableString property to th...