Here is the issue I am having, I have a measure I created in a report I wrote Count (Name). This returns a count of the number of users who have widget A. This report has a 2 level hierarchy btw.
Now, I am trying to replicate the results by creating the measure within the Universe. I created the measure and low and behold when I use it in the report I get a Multivalue error on some of my rows, not all.
I did a little research and I think I need to use the aggregate function?
I beleive you have not selected the aggregation function in the properties of your object. It should be in the advanced tab in the properties of your object.
I resolved the Multivalue issue, unfortunatly I am now getting my counts to return really high values. I believe I am double counting them in certain cases. What are some things I should be looking for in order to resolve this?
[Moderator Note: Moving from General Discussion to Semantic Layer - MichaelWelter]
Make sure that aggregate function in the select of the object is a COUNT(), and that the aggregate function on the Properties tab of the object is Sum.
[quote:ed5c48652d=“ben.marder”]Thanks for the link!
I resolved the Multivalue issue, unfortunatly I am now getting my counts to return really high values. I believe I am double counting them in certain cases. What are some things I should be looking for in order to resolve this?
[/quote]
Don’t forget that an object with a count-function (and a sum-projection of course) in combination with other dimension-objects could result in incorrect (high) results.
A simple example…
data:
dim1 dim2
aaa bbb
aaa ccc
query:
select dim2, count(distinct dim1) as count_dim1 from table group by dim2
results:
dim2 count_dim1
bbb 1
ccc 1
Total 2
2 is not the correct result. It should be 1.
But that is impossible to query in combination with object dim2
(BOB member since 2004-04-09)
(BOB member since 2005-01-06)
(BOB member since 2002-08-08)
(BOB member since 2006-02-06)
(BOB member since 2002-06-20)
of course…