Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle BI + Analysis Services 2005 cube

601248Oct 3 2007 — edited Nov 18 2008

Hi,

I'm currently trying to build an Oracle BI 10.1.3 presentation layer (w/ Answers, Dashboard..etc) with data coming from a SSAS 2005 cube. I've successfully imported the cube in the BI Administration Tool. My question is regarding calculated members in SSAS cube. Specifically, I have a calculated member which simply takes the average of a measure over the count of the current selected set.

My question is: In order to show the calculated members correctly in Oracle BI, what aggregation rule do I need to set for that measure in the Administration Tool? I've tried both "None" and "Aggr_External", but both gave me either an error or incorrect values. However, when I use "Sum" as the aggregation rule, it seems to work correctly.

Has anyone worked with the combination of Oracle BI + SSAS 2005 before? Any answers or feedback would be appreciated.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2008

Added on Oct 3 2007

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

4 comments

1,723 views