MS AS Custom Rollup and Cognos -
01-11-2004
, 10:27 AM
I'm displaying MS Analysis Services 2k cubes using Cognos Powerplay &
PPES v7.0.
One of the cubes holds account balances which are semi-additive. I've
used AS's custom rollup property on the date dimension to successfully
rollup by whowing the latest balances against the date dimension while
summing up against the other dimensions.
However, both Powerplay & PPES complain that the cube doesn't exist
when I try to browse it. NB. the cube displays fine in Powerplay &
PPES without the custom rollup & the cube also displays fine when
browsing with another client (e.g. ProClarity).
Here's the custom rollup MDX
Tail(Filter([Date].[Calendar].CurrentMember.Children,(NOT
IsEmpty([Measures].CurrentMember)))).Item(0)
Does anybody know if this is a known problem? Is there anyway around
it?
Thanks in advance.
Michael Weaver |