TM1 Forum

Hi,

Could you please also mentioned the "Trace Feeder" calculations?

Can you do suppress zero and see whether same values appear for ("Jan-2004",Goal)=25?

If so then it looks like underfeeding.

Regards,

Dharav

declanr wrote:No because your feeder is in 'DataInputCube'; when you change a value in '1f_admin' it has no way of knowing that it needs to reevaluate and fire feeders in 'DataInputCube' without you somehow telling it to.

Except manually re-fire the feeders, is there a best practice approach?

Thanks,

Dharav

The only way I know of to have a feeder re-fire (within the model, not reprocessing feeders/saving rules/etc) is to feed from string value. When a string value changes and it is being used to feed, the feeder will re-fire, and you can structure that feeder to take advantage of any addressing change...

Hi, All

It is resolved. In order to update an alias of an element of control dimension, one has to also turn on alias in the system created subset of the control dimension.


Thank You

Dharav

Hi, All I had updated alias of an element of control dimension. I deployed the app after saving both rights and control dimension rights. After performing above steps, i did not see the element with its new alias in contributor. It still shows old name. FYI: I already saved view. I removed the view ...

I am trying to create a staging cube which is going to send data into 19 cubes for a particular Actual update process. I am not sure what all parameters i need, to assess the feasibility as the staging cube, whether it is going to work properly or how much performance gets bog down. So just want to...

Guys,

It is resolved. That was silly. I did not copy the code properly from notepad. The dimensionelementinsert function should be there and we good to go.

Thnaks for your time.

Thank You

Hello All, I have following code in MY TI: E.g.: #========================================================================== IF ((DIMIX(pDim,pInsert2))=0 & (DIMIX(pDim,pInsert3))<>0 ); DimensionElementComponentAddDirect(pDim, pInsert3,pInsert2, 1); AttrPutS(vlev2,pdim,pInsert2,'A_PC'); IF((DIMIX...

Was the server and admin server shutdown cleanly before updating the certificates? If the certificates were applied whilst running, possible that data could not be written back. Yes. Everything else working fine. All the data which were submitted is good. Two user just entered the data but did not ...

All Experts, After updated the SSL certificate in one of my production server, I had changed the date of my production server to November 26 2016 to see whether everything will functioning or not and during that particular time one of my chore was running automatically that i can see it from my tm1...

Hey Guyzz, need your help and guidance I have updated my TM1 server with the updated certificates. Now the prob is I am not able to login to any of the TM1 server through ARCHITECT, but after updating the Certificate Authority path in perspective and TM1p.ini I can login through perspective. Need H...

The second way is more than likely faster because you are using a static subset in your data source rather than a dynamic one, like with the MDX. The best of both worlds would be to use MDX to create a static subset. Just use this syntax: SubsetMDXSet(pDim, sSub, '{TM1FILTERBYLEVEL( {TM1SUBSETALL( ...

Hi, All I notice following while testing my TI process: My all other TI code remain same except the code to create the subset. => When i use following code, MY TI takes 1 min 30 seconds. IF( SubsetExists( pDim, sSub) = 1 ); SubsetDestroy( pDim, sSub); ENDIF; SubsetCreateByMDX(sSub,'{TM1FILTERBYLEVEL...

Hi, Declanr I could not achieve the my objectives by just placing following dimension sort order function. I implement both dimension sort order function and (attributes based & element Level based) MDX to create subset and sort only parent of child elements in customized order. It works now as ...

@declanr: Thanks for correcting me. I insert the following syntax in MetaData: DimensionSortOrder(pDim, 'ByInput', 'Ascending','ByName' , 'Ascending'); Result: Consolidation Elements order remains same - Expected behavior as CompSortType is "ByInput" Child elements order also remains same ...

I created the generic process to enter the new elements in the dimension while uploading the actual data. It works except the dimension sort order. Hierarchy: Consolidation A Consolidation B Consolidation C 90012345678 90012345679 90012345680 90012345675 ----> Process entered his element while uploa...

@xavier 13: Have you tested in FP5? I have 10.2.2 FP5 and perspective works good except the rebuild current book option behavior. In Excel 2010, If i click on Rebuild Current Book option than it recalculates data in one sheet and move to different sheet and we can see that. At the end, it stops on t...

as Wim suggest: asciioutput helps. ***the TI takes the word after comma " , " to the next column, so in that case, my column data are not correct. what should I do ? - is it string data containing ","? If string than Tab delimiter and if number than comma delimiter should resolve...

I got it!! }tp_application_state control cube is the place where you can manipulate the logic. It works. 1) Zero Out data for required approval hierarchy elements in this cube 2) get the details of the user who runs the process 3) Insert data in to }tp_application_state cube (it would work like taki...

Hello All, Environment: 10.2.0 We have approval application has been placed. Business Case: Users are consolidating their branch data in to their excel sheet. Few users are copying and pasting data from their excel sheet to TM1 contributor. I created an excel sheet using DBSW formula to send data di...