Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
ROLAP fact table dimension causes Excel2007 Show Detail to fail
0 views
Skip to first unread message
Jerome
Dec 3, 2009, 7:21:01 AM12/3/09
to
Hi, I have a ROLAP dimension based on the fact table with TransactionNo as
key and TransactionText as Name. This causes Show Detail (Excel2007) to
always return 0 rows, but when I change to MOLAP it works OK.
key and TransactionText as Name. This causes Show Detail (Excel2007) to
always return 0 rows, but when I change to MOLAP it works OK.
Can't I have Rolap dimensions and use "Show Details" ?
PS ! I want the dimension to be used by ExcelXP users (no "Show detail" in
XP) without increaseing the cube size to much.
/Jerome
AS2005 sp3
0 new messages