dbTalk Databases Forums  

MS AS Custom Rollup and Cognos

comp.databases.olap comp.databases.olap


Discuss MS AS Custom Rollup and Cognos in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Weaver
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.