In Analysis Services 2005, using the Business Intelligence Wizard in the BI Development Studio to add time calculations to a cube worked fine when only base measures are included in the scope. When a calculated measure is added to the scope of the Business Intelligence Wizard time calculation, all that is returned for the Business Intelligence Wizard time calculation value is “NA”. What could be the problem/how can I make this work correctly?
The exact same time calculation was being created by the Business Intelligence Wizard - the only difference was adding one calculated measure to the scope. Could this have anything to do with pass and solve order? Do the measures that the calculated measure depends on also have to be listed in the scope for the BI Development Studio time calculation? I'm sort of reaching here.
Any help is appreciated,
Dan
There are two separate issues, both of which have been fixed for the next CTP:
1. A redundant scope is created when both physical and calculated measures are chosen.
2. Seeing NA in the context of calculated measures.
The only *possible* workaround I know of for issue 2 is to edit the MDX script and replace the AGGREGATE function with SUM, but this should only be done if you are postive that it makes sense to sum the measures in question. Applying this change may then cause you to hit issue 1, at which point you would, if needed, want to remove the first (outer scope) and move those physical measures into the inline scopes (on the left hand side of the '=').
-rob|||Thanks for the thorough explanation. I will attempt to apply the solution(s).
Dan
|||Is a CTP planned between now and the final release?|||Yes, there will be another CTP released in the near future.
-rob
No comments:
Post a Comment