on 10-23-2015 3:51 PM
Hi,
I have a hierarchy which I am using with a SAP BW BICs connection.
I have add an input control to exclude certain members if needed but the total doesnt seem to adjust. For example,
UK = 150
- England = 50
- Wales = 50
- Scotland = 50
If I exclude Wales I still see 150 for UK. UK is not an actual member it is a node in the hiearchy so not sure why it isnt being re-calculated?
UK = 150
- England = 50
- Scotland = 50
Cheers
Hi Leo ,
It's a product behavior .
2185759 - In Web Intelligence, selecting a value in Input Control does not correctly update aggregate totals in report
queries containing a measure associated to a hierarchical object return all the different aggregations possible in the hierarchy. Indeed, OLAP sources always return hierarchical data with preaggregated values at all node levels. This is by design.
This explains why the aggregations of hierarchical data in Web Intelligence are not calculated locally but are the values from the data source. In consequence, they are not impacted by local filters or member selection.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.