Difference between revisions of "Auto Aggregate items using hierarchies"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
[[File:Add Hierarchy.png |Aggregate button|400px]]<br> | [[File:Add Hierarchy.png |Aggregate button|400px]]<br> | ||
| + | |||
| + | Fusion Data Browser will display the individual items along with a Total. | ||
| + | |||
| + | [[File:Aggregate - FDB1.png |Aggregation in Fusion Data Browser|800px]]<br> | ||
| + | |||
| + | When querying the data, the Total is available along with all the individual items which make up the total. | ||
| + | File:Aggregate - WS.png | ||
| + | |||
| + | [[File:Aggregate - WS.png |Aggregation in Web Services|800px]]<br> | ||
Revision as of 09:46, 3 April 2024
Overview
Auto Aggregation changes the result of a data query as see in Fusion Data Browser or via Webservices.
To use the Hierarchy feature, first you must create a hierarchy using the appropriate codes. You can read how to do this in article.
Next, link the hierarchy to a dataflow and using the Aggregation area.
Use the Add Hierarchy button to select which Dimension and which Hierarchy is to be used.
Fusion Data Browser will display the individual items along with a Total.
When querying the data, the Total is available along with all the individual items which make up the total. File:Aggregate - WS.png
