Wim Gielis wrote: ↑Mon Sep 17, 2018 7:15 am
Wim Gielis wrote: ↑Mon Sep 17, 2018 6:45 amSomeone who has the time to play around with it ?
5 minutes can always be donated
A TI process with a dynamic level 0 subset as the data source, and the Metadata inserting an N-level element in the dimension,
will have the Data tab including this new element.
Anyone who can test in a different version ?
Env: 10.2.2 FP7
Test:
1. Created a new dimension (called
test)with the following:
Total
...1
...2
...3
...4
...5
...6
...7
...8
...9
...10
2. created a dynamic mdx subset, with express: {TM1FilterByLevel({TM1SubsetAll([Test])},0)}
which shows elements 1 to 10.
3. created TI with the following:
Prolog:
DatasourceType = 'SUBSET';
DatasourceNameForServer = 'Test';
DatasourceSubset = 'mdx_level0';
Metadata
ASCIIOUTPUT( 'metadata_tab.txt', v1 );
sNewElem = NUMBERTOSTRING(NUMBR(v1)+100);
DimensionElementInsert( 'test', '', sNewElem , 'N' );
DimensionElementComponentAdd( 'test', 'Total', sNewElem , 1);
Data
ASCIIOUTPUT( 'data_tab.txt', v1 );
Compared output files:
metadata_tab.txt ... showing elements 1 to 10.
data_tab.txt ... showing 1 to 10, plus newly added elements.
I would say it is a confirmed scenario where datasource gets reassessed before processing data tab.
I guess this scenario (where target is also source) doesn't get used often enough.
Good to know.
