It should be possible to get an aggregated total value across dynamic selections from the OLAP server.
Example: get a total revenue value accross selected products matching a certain criteria.
So it should be possible to get an aggregated total of a subset out of a single PALO.DATA formula,
PALO.DATA ("myDB","ProductCube",PALO.SUBSET(<filter/conditions>), ...)
instead of only getting the value for dimension elements via:
PALO.DATA ("myDB","ProductCube","ProductGroupA", ...)14 votes
- Don't see your idea?