on ‎2017 Mar 30 5:46 PM
The aggregation level is on a Info Provider which is a infocube , so does any data coming to the I_VIEW (Incoming planning data to a AMDP) comes aggregated by default or un - aggregated . And what would be the case if the Aggregation level was on a DSO .
IF it comes aggregated then I can use a statement
SELLDAYS = SELECT FISCPER , PHSELLDAY FROM :I_VIEW
WHERE INFOPROV = 'PHFIBPCST' ;and if un-agrregated, I will need to put group by clause
SELLDAYS = SELECT FISCPER ,sum( PHSELLDAY) FROM :I_VIEW
WHERE INFOPROV = 'PHFIBPCST'
group by FISCPER;
Request clarification before answering.
| User | Count |
|---|---|
| 15 | |
| 11 | |
| 11 | |
| 4 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.