TM1 Forum

Great idea!

Will definitely try and report.

Thanks a lot!

Keneth

burnstripe wrote: ↑Sun Jun 13, 2021 10:40 am Have you considered making % a consolidated element with $ as it's child. As long as there's no requirement to input % and it's always a calculation this is an option that'll remove the need for feeder statements.

Hi Wim, Thanks for the response. Unfortunately the answer is yes. Basically the whole purpose is to get the % calculation on consolidated level only. In the example shown, I need the 43.53% and couldn't show it unless the % calculation is applied to all leaf elements. Kenneth Do you need to feed any...

Hi, I need some help in feeding a calculated consolidated cell. The attachment shows the test cube. A simple explanation of what I'm trying to do here: I'm trying to have % calculation based on "Change" divided by "Opening" but only on subtotal level. I tested feeders on detail l...

Thanks for the reply. I realized I used the wrong word "Modeler", the users are actually licensed as "Performance Management" user which means they are not admin. but regular user who can read and write data into TM1. Again I was wondering whether identifying a few of these users...

Hi,

Can I assign user licensed under Performance Management to become ReadOnlyUser in }ClientProperties?

I currently have a few Local Explorer licenses to match ReadOnlyUser but wonder whether I can allow more.

Thanks!

Kenneth

Thanks Tom and Wim. Just tested and realized I forgot to name the DataSourceCubeView. It works right after. To provide details, I was trying to put text to consolidated intersections based on certain criteria. There's no source data cube so to speak but I named the target cube as the source to get t...

Hi, I have done many TI to transfer data based on source view and target view. For all of them I configure dimensions in the source cube for the data I need to transfer. For the target cube, I create target subsets, target views to clear data, data will be loaded based on elements in the source cube...

Looks like it's the ViewExtractSkipCalcsSet that needs to be inserted.

Thanks very much!

ascheevel wrote: ↑Thu Oct 08, 2020 6:16 pm Can you add the below items to your prolog below the other ViewExtract... declarations and re-test?

Code: Select all

ViewExtractSkipCalcsSet('tDemo', 'tView', 0);
ViewExtractSkipRuleValuesSet('tDemo', 'tView', 0);

Hi all, For simplicity, I created a very small cube to show what I'm trying to accomplish. The cube includes: DimA - (A-TOTAL)->A1, A2 DimB- (B-TOTAL)->B1, B2 Dim_m- $, Description What I'm trying to do is to put string into "Description" for consolidated elements (A-TOTAL), (B-TOTAL) when...

Make sure your TI source view isn't skipping consolidations: ViewExtractSkipCalcsSet? Thanks for the reply. I checked the view and it does include the consolidated elements. I've been testing by changing the CellPutS to special consolidated elements instead of variables and it worked. But I need th...

Hi all, I have trouble writing to consolidated element of a cube. Here's some details of how I setup the TI process: Data Source: Cube View - Target cube Variables: Based on Target cube dimensions, Variable Type all "String", Contents all "Other" Prolog: 1. Setup Target view and ...

Glad it helped. At least I'm not the only one. Ken Today I encountered this 'not calculating' issue as awell While I created a new cube in explorer and tried to use DB to mirror the source cube to the targeted cube. I copied and modified the rules from consultant (thank you) and the cube view are al...

Correct. But CellIncrementN is definitely more convenient.

Thanks!

Wim Gielis wrote: ↑Wed May 06, 2020 1:00 pm If you forgot about that function, there is still CellGetN to retrieve the value in the cube, then add the new value of the data source, then CellPutN of the sum of both to the cube (same intersection).

Do you need to keep track of each record individually? (In which case you need to introduce some kind of transactional dimension as per Wim's suggestion). Or is it possible to cummulate the duplicate cube address intersections? (In which case you could just use CellIncrementN not CellPutN) Thanks. ...

Hi, I'm loading a file with duplicate records. To load all records I need to identify each row with a unique identifier. To solve this I can create a dimension for record count and create a new element for each line so that no record will be overwritten due to duplication. I'm thinking to use the di...

Probably. But for simplicity I'd rather not create another process to do the job. Thanks! Try updating attribute with RunProcess, so it commits entirely outside of the processing chain. CubeSaveData must be added after attribute update. - No, it only matters if you want to serialize changes to the d...

I tried implementing the suggested solution.

Just moving the load process to Epilog won't work.

CubeSaveData must be added after attribute update.

Thanks to all.

Kenneth

Got it. In my case I'll probably separate the processes and test. Thanks for your input. Kenneth Actually the way the attribute working is just a "Y" under the attribute "Active" in the "Version" dimension. Well, that's not exactly how it works because just setting some...

Thanks for the reply. Actually the way the attribute working is just a "Y" under the attribute "Active" in the "Version" dimension. If my situation is the same as yours then can we say that update due to attribute only "really" happens when the process series ...

Hi, I have the following: 1. Cube has rule calculation for only "Active Version" 2. Active Version is attribute in Version dimension 3. Cube subject to Year End Process ("YEpro") 4. YEpro calls for 2 processes: a. "Export" and b. "Import" 5. Export includes ru...