requestAtleastFields with Smart Chart - Not sending the fields to backend

[sreehari_vpillai]

Hi Experts ,

I am on 1.38 UI5 library version . I have a smart chart , which is bound to an OData service ( generated out of a CDS which has aggregated nodes ) . The user is given option to choose which ever the dimensions and measures available in the p13n dialog. Coming to the question , I want to send a list of predefined columns irrespective of what the user choose ( say the user chose A,B & C, I want to append C & D always ) .

I am using requestAtleastFields property of Smart Chart . But, when I check the OData call , it is not sending these fields. Any pointers ?

<smartchart:SmartChart
requestAtLeastFields="SalesAmount,TaxAmount,InvoiceAmount" ( these are th efields I always need)
enableAutoBinding="true"
entitySet="ZCDS_CUST_INV_SALES"
useVariantManagement="true" 
persistencyKey="salesperformance_c1"
useChartPersonalisation="true" header=""
showFullScreenButton="true" 
selectionMode="Single"
showChartTooltip="true" 
showDrillBreadcrumbs="false"
showDetailsButton="false"
showDrillButtons="true"
showSemanticNavigationButton="true">
					
</smartchart:SmartChart>

[maheshpalavalli · Accepted solution]

Hi Sreehari V Pillai,

When I degubbed the code, I found that requestAtLeast fields will only work for the dimensions and not for the measures unfortunately 😞

I guess you have to move to analyticalQuery only.. BTW when I used @DefaultAggregation: #FORMULA in the Normal CDS View and activated the CDS, it didnt give any errors.. I think it works with normal cds view as well

BR,

Mahesh

[sreehari_vpillai · Accepted solution]

Yea, it works only with dimensions . Adding @DefaultAggregation: #FORMULAactivates the CDS but the formula calculation does not take place unless we make it a query . Will see for any alternatives and keep it posted here. I appreciate your helps.

Sreehari