dbTalk Databases Forums  

Re: By Account Aggregation Function

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.olap Re: By Account Aggregation Function

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Re: By Account Aggregation Function in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vladimir Chtepa
 
Posts: n/a

Default Re: By Account Aggregation Function - 01-16-2006 , 12:34 AM





What Server Edition do you deploy to?

"Liran" <Liran (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello All,

I have tried creating a sample SSAS Project, using the AdventureWorksDW
DB.

I have created an account parent-child dimension using an account
dimension
type.

I'm using the measure Amount from the FactFinance table, and used the
ByAccount aggregateFunction property for that measure.

The problem is, when deploying that project I get the following error:

Aggregation function NONE specified for mapping account type Statistical
is
not supported for ByAccount semiadditive measure.

The Statistical account type aggregation function is set by the business
intelligence wizard to None. I see no way to change it.

Does anyone see what's the problem here?



Reply With Quote
  #2  
Old   
Vladimir Chtepa
 
Posts: n/a

Default Re: By Account Aggregation Function - 01-16-2006 , 06:31 AM





Hi,

It seems to be a bug, but only MSFT people could confitrm it

Vladimir Chtepa

"Liran" <Liran (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:E3190F45-97C8-43EA-857B-5D2C0247B5FD (AT) microsoft (DOT) com...
Quote:
Development edition
Microsoft Analysis Server 9.00.1399.06

"Vladimir Chtepa" wrote:

What Server Edition do you deploy to?

"Liran" <Liran (AT) discussions (DOT) microsoft.com> wrote in message
news1149A5A-701C-4FB6-B6F7-A4D5E27D2E36 (AT) microsoft (DOT) com...
Hello All,

I have tried creating a sample SSAS Project, using the AdventureWorksDW
DB.

I have created an account parent-child dimension using an account
dimension
type.

I'm using the measure Amount from the FactFinance table, and used the
ByAccount aggregateFunction property for that measure.

The problem is, when deploying that project I get the following error:

Aggregation function NONE specified for mapping account type
Statistical
is
not supported for ByAccount semiadditive measure.

The Statistical account type aggregation function is set by the
business
intelligence wizard to None. I see no way to change it.

Does anyone see what's the problem here?



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top