AnsweredAssumed Answered

duplicate dimensional data

Question asked by Kery on Feb 5, 2011
Latest reply on Mar 31, 2011 by Kery
I have been fighting with a rather complicated portlet most of the week, and am hoping someone can give me some ideas.

So the issue in a nutshell is that the query is returning more data than the portlet returns. The portlet is only displaying one line item for a project, even though I have defined the project id in the dimension:

@SELECT:DIM:USER_DEF:IMPLIED:Q:cast(q.ResourceID AS Varchar)+cast(q.ProjectID AS Varchar)
+q.Month:ID@,

What am I missing? Shouldn't the above prevent the portlet from only displaying one project code/name per resource?

Outcomes