cancel
Showing results for 
Search instead for 
Did you mean: 

Aggregation Function Missing

0 Kudos

Hi,

I have recently started using BOBJC as a local setup using an Excel file as data source for replication.

I could not trace the Aggregation functions in the Story creations i.e. functions like Count Distinct, Sum , Average etc.

I went through the help document and it mentions the following regarding Aggregation function.

  • Only local SAP HANA models support aggregations. Remote connections are not supported.
  • An existing aggregation cannot be used to create another aggregation.

Please advise how these functions can be made available for the story creation in local setup with excel file as data source.

Looking forward to your support.

Regards,

Kumar Ankur

Accepted Solutions (1)

Accepted Solutions (1)

TammyPowlas
Active Contributor
0 Kudos

Kumar,

I am not sure I follow

Aggregations in general are done in the modeling when using an Excel file

Is your question related to a calculation?

0 Kudos

Hi Tammy,

Thanks for your response.

Actually i want to know how to do a "count distinct" in the story creation. E.g. the data contains Customer IDs against multiple products. I want to know the distinct Customer IDs available in the data.

Because, when I am creating a story with Column chart, it is showing the sum of Customer IDs and not the count of IDs.

Please let me know if i am able to convey my message clearly, your support will be very helpful.

Thanks & Regards,

Kumar Ankur

0 Kudos

Hi Kumar,

Could you please check this SCN Thread it might be useful for you.

Thanks,

Mark

0 Kudos

Hi Mark,

Thanks for response. I think the query is still unresolved.

Because there is still no option to get COUNT as aggregation type for Excel/flat file data source.

Regards,

Kumar Ankur

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

i think we can conclude COUNT aggregation isn't in the product for flat-file data. I've seen the enhancement request logged internally, but i can't comment on the priority nor acceptance.

At the time of writing, the workaround proposed in the other thread is your most likely solution.

regards,
H

0 Kudos

Hi Tammy,

I am summarizing my question in order to make it simplae to understand


Where can we define Aggregation Types MAX, MIN, COUNT in Modelling when using an Excel file?





TammyPowlas
Active Contributor
0 Kudos

Kumar:

The Modeler can define aggregations when using an Excel; I thought I answered this earlier.

I believe Henry and Mark have answered your questions

Answers (0)