Re: Time business inteligence - why it does not work on lowest time level (64bit version)?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Peter,

Thanks. That is what I was looking for.

Regards,

Vimmas


"Peter Yang [MSFT]" <petery@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:BMaX07pQGHA.8072@xxxxxxxxxxxxxxxxxxxxxxxx
Hello Vimas,

Based on my further research, this is a known issue and you could refer to
the following article to fix this problem:

912136 You may experience problems after you run the Business Intelligence
Wizard to add time calculations in SQL Server 2005 Analysis Services
http://support.microsoft.com/default.aspx?scid=kb;EN-US;912136

Sorry for any inconvenience brought.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no
rights.


--------------------
From: "Vimas" <Vimas@xxxxxxxxxxxxx>
References: <upCudpWQGHA.1868@xxxxxxxxxxxxxxxxxxxx>
<fz4UTRbQGHA.752@xxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Time business inteligence - why it does not work on lowest
time level (64bit version)?
Date: Tue, 7 Mar 2006 09:06:06 -0500
Lines: 180
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
Message-ID: <OzeyIBfQGHA.5808@xxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.sqlserver.olap
NNTP-Posting-Host: cpe001310f5a811-cm0012c90f99c6.cpe.net.cable.rogers.com
70.29.102.55
Path: TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.olap:67825
X-Tomcat-NG: microsoft.public.sqlserver.olap

Hi Peter,
Could you please explain workaround you posted? It looks like exactly same
line from old code. Maybe order it is placed it is important?

Also, I would disagree with you that problem is in script generated by the
wizard. I can replace code with very simple lines created by me:
Add following code to the end of the script:

Create Member CurrentCube.[Date].[Calendar Date Calculations].[Calc2] AS
"NA" ;
Scope({[Measures].[Internet Sales Amount]});
( [Date].[Calendar Date Calculations].[Calc2],
[Date].[Calendar].Members) = ([Date].[Calendar].CurrentMember,
[Date].[Calendar Date Calculations].DefaultMember);
End Scope ;

This is simple script that supposed to make values of Calc2 same as
original
values.

Now again - in filter area this does not work just at lowest hierarchy
level! Yet same dimension droped in column area works.

Thanks for your help





"Peter Yang [MSFT]" <petery@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:fz4UTRbQGHA.752@xxxxxxxxxxxxxxxxxxxxxxxx
Hello Vimas,

I was able to reproduce the issue on my side. I found [Day Over Day
Growth]
is set to "NA" in calculations. It seems the script generated by the
wizard
has issues. You need to manaully add the caluated member to work around
the
issue.

================================
Create Member CurrentCube.[Date].[Calendar Date Calculations].[Day Over
Day
Growth] AS "NA" ;
================================

Please rest assured that this issue has been routed to the proper
channel.
If there is any update, we will let you know.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no
rights.


--------------------
From: "Vimas" <Vimas@xxxxxxxxxxxxx>
Subject: Time business inteligence - why it does not work on lowest time
level (64bit version)?
Date: Mon, 6 Mar 2006 17:07:29 -0500
Lines: 87
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Original
Message-ID: <upCudpWQGHA.1868@xxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.sqlserver.olap
NNTP-Posting-Host:
cpe001310f5a811-cm0012c90f99c6.cpe.net.cable.rogers.com
70.29.102.55
Path: TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.olap:67807
X-Tomcat-NG: microsoft.public.sqlserver.olap

NOTE: I have to point out that I am working with 64 bit Analysis
Services
version, and have not tried the same on 32 bit version.

Hi,

I am having problems in adding time business itelligence into my cube
logic.
Basically in my cube structure I have big problem making in work.
I'll try here to reproduce problem with Adwenture works example.

1. Open Adventrure works project
2. Open cube Adventure works
3. Go to menu "Cube"->"Add Business Intelligence..."
4. Select "Define Time intelligence" and then click Next
5. Choose "Date\Calendar" for hierarchy and then "Day over day growth"
as
calculation. Click "Next"
6. Choose "Internet Sales Amount" as measure. Next
7. Finish

Date dimension structure is changed and following code is added:
/*
Begin Time Intelligence script for the [Date].[Calendar] hierarchy.
*/
Create Member CurrentCube.[Date].[Calendar Date Calculations].
[Day Over Day Growth] AS "NA" ;

Scope(
{
[Measures].[Internet Sales Amount]
}
);
( [Date].[Calendar Date Calculations].[Day Over Day Growth],
[Date].[Date].[Date].Members ( 1 ) : Null ) =
( [Date].[Calendar Date Calculations].DefaultMember ) -
( [Date].[Calendar Date Calculations].DefaultMember,
ParallelPeriod(
[Date].[Calendar].[Date],
1,
[Date].[Calendar].CurrentMember
)
) ;

( [Date].[Calendar Date Calculations].[Day Over Day Growth],
[Date].[Date].[Date].Members ( 0 )
) = Null ;
End Scope ;
/*
End Time Intelligence script for the [Date].[Calendar] hierarchy.
*/



Now go to "Browser" tab.
In filter area add new hierarchy [Date].[Calendar date calculation] ,
leave
default value as 'Current date'
In row area add hierarchy [Date].[Calendar].
In measure area drop measure [Internet Sales Amount]


Expand [Date].[Calendar] hierarchy to see days of July 2004. Everything
seems normal.
Now change [Date].[Calendar date calculation] value to [Day over day
growth]. All values became NA
Now drag [Date].[Calendar date calculation] dimension and rop into
column
area. Now some values are OK, some NA.
Actually that part is explainable - Day over day growth is defined just
on
day level.

But why day values are NA when [Calendar date calculation] is in filter
area??????????????????????????????
This is very consistent problem and I believe this is a bug and I need
help
finding workaround. Also I can point out that for me time intelligence
(Different calculations) works if it is defined not at the lowest level
of
hierarchy (Month, Quarter, etc)


My problem is a bit different, and I am using this just to demonstrate
that
at day level this calculation does not work.

Thanks for help

















.

Relevant Pages