I was working on optimizing rules and feeders and thought of this:
Scenario - flowing the data from one cube to another.
Condition - the data of only those versions that are under rollup 'Active Versions' has to be flown.
Possibility - there can be more than 1 version under 'Active Versions' but possibly only 1 version has data in it and remaining have zero data.
Following are two cubes:
test_MasterCube ---> data --> to test_ReportingCube.
I created another cube Feede_Version (actually I misspelled it, wanted to name it Feed_Version). I provide the name of only that version that I want to feed.
Feeders in test_MasterCube:-
Code: Select all
[ 'Amount'] =>
DB('test_ReportingCube',
DB('Feede_Version',!Version,'Feed_Version')
,!Fiscal_Year,!Period,!plan_chart_of_accounts,'Amount') ;
Or is there any more efficient way to address this.
Thanks
KD