dbTalk Databases Forums  

"ALL" level seems incorrect in BI Accelerator1.2

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


Discuss "ALL" level seems incorrect in BI Accelerator1.2 in the microsoft.public.sqlserver.olap forum.



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

Default "ALL" level seems incorrect in BI Accelerator1.2 - 01-13-2005 , 12:45 PM






I am using BI Acclerator 1.2 and there seems to be a problem with the way the
"ALL" level works with the auto-created calculated members.

When selecting ALL, the calculated members, such as YTD, Current Year, etc.
are also rolled into the total; creating a summed value that is 6X larger
than it should be.

Is there a work around for this?

Thanks,
Bill

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: "ALL" level seems incorrect in BI Accelerator1.2 - 01-13-2005 , 05:09 PM






Not is should not be.
I am running 1.1 and I don't see that with SMA01.
Did you generate the SMA01 sample data -- is it happening there?
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

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

Quote:
I am using BI Acclerator 1.2 and there seems to be a problem with the way
the
"ALL" level works with the auto-created calculated members.

When selecting ALL, the calculated members, such as YTD, Current Year,
etc.
are also rolled into the total; creating a summed value that is 6X larger
than it should be.

Is there a work around for this?

Thanks,
Bill



Reply With Quote
  #3  
Old   
billd
 
Posts: n/a

Default Re: "ALL" level seems incorrect in BI Accelerator1.2 - 01-14-2005 , 08:27 AM



Hi Dave. I'm not using SMA; however I used it as a basis for my own
application (via the MAKE WORKBOOK A NEW TEMPLATE button)

Is there any way to configure BI Accelerator not to generate the calculated
members? This would probably be the easiest fix for me.

"Dave Wickert [MSFT]" wrote:

Quote:
Not is should not be.
I am running 1.1 and I don't see that with SMA01.
Did you generate the SMA01 sample data -- is it happening there?
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"billd" <billd (AT) discussions (DOT) microsoft.com> wrote in message
news:52870A23-C248-43D9-A47C-88F3D2B77AD3 (AT) microsoft (DOT) com...
I am using BI Acclerator 1.2 and there seems to be a problem with the way
the
"ALL" level works with the auto-created calculated members.

When selecting ALL, the calculated members, such as YTD, Current Year,
etc.
are also rolled into the total; creating a summed value that is 6X larger
than it should be.

Is there a work around for this?

Thanks,
Bill




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