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

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.


--------------------

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 (AT) online (DOT) microsoft.com> wrote

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...b;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.


--------------------

Peter,

Thanks. That is what I was looking for.

Regards,

Vimmas


"Peter Yang [MSFT]" <petery (AT) online (DOT) microsoft.com> wrote