I would like to create hierarchy inside spago BI tool to make drill down in it, after going through the Tutorial provided by your team I have found that there is option
called "$P{ ParKpiHierarchy}".
Do i need to add this option to spagobi.xml configuration file ??
And If I'm right so far, how to write this tag into the xml config. file ??
Also I have other question about creating KPI's:
In this link of your tutorial
http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/Kpis+Definition#HDataSetDefinition I have found that in the query you write "$P{ ParKpiResource}" is this necessary to create KPI ???
or Can i create KPI without using this options inside the dataset query I'm generating ??
HI, I think that you don't need a KPI Hierarchy, you just need cti configure a KPI MOdel which has a hierarchical structure. Each node of the model can befilled with a KPI.
The Hierarchy you are accessing through the $P{ ParKpiHierarchy} is the one containing the organizational units for granting organizational units to some KPI nodes of the model.
$P{ ParKpiResource} can be used to modify the result of your dataset depending on the resources associated to the model (instance) of you KPI model.
Hope it's clearer now!