Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Computation for my KPI's happen on Big Data Platform rather than on reporting tool

Computation for my KPI's happen on Big Data Platform rather than on reporting tool

New Contributor

I want to store my data on Hadoop such that all the computation for my KPI's haapen on Big Data Platform rather than on my reporting tool. One way i thought was to create a base table in hive and then an intermediate aggregate table from which my final table would take data to calculate my final KPI's. But issue with this is, I want to define business rule for my KPI's so that whenever a new KPI or column is added it follows the rules defined earlier. Can anyone shed some light or ideas on this part, how can i do this?

Shubh