TM1 Explorers: Explore, Challenge and Summit with TM1 › Base Camp Forums › TM1 Technical › Turbo Integrator › TI process skipping data section
-
TI process skipping data section
Posted by Helen on 10-May-22 at 8:36 pmHi all. I’m brand new here so please accept my apologies if I don’t follow the expected protocols.
I’ve just created a new process to transfer data from one cube to another and it seems to be completely skipping the data section. I’ve never had this before. I’m sure it’s probably something really obvious but I just can’t get my head around it.
I’ve added ASCIIOutput procedures to the prolog, data and epilog sections to see if I can figure out what it’s doing. The prolog and epilog logs are generated but noting is even generated for the data section.
I’ve attached the procedure in a txt file.
p.s. I’d usually use rules for transferring data rather than a process but in this instance I couldn’t get it working with the mapping involved which uses a a matrix. Maybe I should just concentrate on getting that route working ?
Thanks for your help.
Helen replied 1 year, 10 months ago 3 Members · 4 Replies -
4 Replies
-
0 Diamonds2 Gold260 ExperienceScout
Did you check if the SourceView contains any data? Does it include any rule calculated or consolidation elements?
-
2 Diamonds14 Gold2,180 ExperienceHiker
Just seconding @teamone‘s suggestion. You need to make sure that the source view actually contains data. So open it, suppress zeros and move everything except one dimension into rows. then select the lowest level of each dimension for all dimensions. You should have editable data there. If it’s not editable at the base level, you probably have rules that are calculating all the data in the cube. In this case please see this post https://exploringtm1.com/viewextractskiprulevaluesset/ that will explain how to extract rule calculated values. Cheers, John
-
0 Diamonds2 Gold160 ExperienceScout
Thanks both. I suspect the source data is rule based so I’ll check out that link.
-
0 Diamonds2 Gold160 ExperienceScout
Perfect!!!
I just needed to add:
ViewExtractSkipCalcsSet (cbSource , SourceView , 0);
ViewExtractSkipRuleValuesSet (cbSource , SourceView , 0);to my source definition.
Thank you so much guys!
-
Log in to reply.