Hi everyone,
I have been struggling with the following for quite a while now. In my Aggregate Measurement I have a view which specifies different items at different times (rows) with different granularity (columns). Some of the items have an inventdimid some of them do not (i.e., field is empty). Still I would like to add an Aggregate Dimension (table is inventdim) with relationship on the inventdimid. If I do exactly this and publish this Aggregate Measurements, I only obtain items which have an inventdimid specified.
This case obviously stretches to the general case in which I want to allow rows with empty ids in the central view of an aggregate measurement, have an Aggregate Dimension with relation to this id and still obtain all rows from the central view in the result.
Does that make sense? Is it intended in the current way? Do you see any solution?
Thanks a lot, Jonas