TM1 Explorers: Explore, Challenge and Summit with TM1 › Base Camp Forums › TM1 Technical › Turbo Integrator › TI process skipping data section
TI process skipping data sectionPosted by Helen on 10-May-22 at 8:36 pm
Hi 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.
Administrator11-May-22 at 2:27 pm2 Diamonds14 Gold2,170 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
Member13-May-22 at 9:00 pm0 Diamonds2 Gold160 ExperienceScout
Thanks both. I suspect the source data is rule based so I’ll check out that link.
Member13-May-22 at 9:29 pm0 Diamonds2 Gold160 ExperienceScout
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.