Hi team,
can we enable a feature on smart import, where if I upload the data at the agregated level then Board automatically splits in the existing ratio.
If the ratio is not present, then it splits equally on all the tuples.
Example:-
- Suppose my cube has existing values as below where the total is 1600 at the base granularity.
2. Now, suppose I Upload the data via smart import in the same cube, but only by Week & Country like below
3. now the Smart import should show successful data upload and the underlying values should automatically change like below totaling to 2000
We can call the feature as Split & Splat by Smart Import.
In the backend the logic cube be like below:-
1. Create a temp cube same as smart import
2. check if temp cube and the target cube is at same dimension
3. If yes, then do a simple b=a dataflow
4. If No, then do the split as per the existing ratio
thanks,
Aniket
