Hey all,

Ive just created a time business intelligence function with SQL 2005.
But when i got to view the data in the browser, it give me NA back. It
has to do with the day over day calculation. Now im pretty sure it has
to do with the fact that the code created by the business intelligence
tells it to show NA. Code created by BI:

Create Member CurrentCube.[Snapshot].[EffectiveDate Snapshot
Calculations].
[Day Over Day Growth %] AS "NA" ;

Create Member CurrentCube.[Snapshot].[EffectiveDate Snapshot
Calculations].
[Day Over Day Growth] AS "NA" ;


Scope(
{
[Measures].[Cumulative Realized Profit]
}
);

( [Snapshot].[EffectiveDate Snapshot Calculations].[Day Over Day
Growth %],
[Snapshot].[EffectiveDate].[EffectiveDate].Members ( 1 ) : Null ) =


(
( [Snapshot].[EffectiveDate Snapshot Calculations].DefaultMember )
-
( [Snapshot].[EffectiveDate Snapshot Calculations].DefaultMember,
ParallelPeriod(
[Snapshot].[EffectiveDate].[EffectiveDate],
1,
[Snapshot].[EffectiveDate].CurrentMember
)
)
)
/
( [Snapshot].[EffectiveDate Snapshot Calculations].DefaultMember,
ParallelPeriod(
[Snapshot].[EffectiveDate].[EffectiveDate],
1,
[Snapshot].[EffectiveDate].CurrentMember
)
) ;

( [Snapshot].[EffectiveDate Snapshot Calculations].[Day Over Day
Growth %],
[Snapshot].[EffectiveDate].[EffectiveDate].Members ( 0 )
) = Null ;

Format_String (
[Snapshot].[EffectiveDate Snapshot Calculations].[Day
Over Day Growth %]
) = "Percent" ;

( [Snapshot].[EffectiveDate Snapshot Calculations].[Day Over Day
Growth],
[Snapshot].[EffectiveDate].[EffectiveDate].Members ( 1 ) : Null ) =


( [Snapshot].[EffectiveDate Snapshot Calculations].DefaultMember ) -
( [Snapshot].[EffectiveDate Snapshot Calculations].DefaultMember,
ParallelPeriod(
[Snapshot].[EffectiveDate].[EffectiveDate],
1,
[Snapshot].[EffectiveDate].CurrentMember
)
) ;

( [Snapshot].[EffectiveDate Snapshot Calculations].[Day Over Day
Growth],
[Snapshot].[EffectiveDate].[EffectiveDate].Members ( 0 )
) = Null ;

End Scope ;

Now notice the first two paragraphs of code, there is 'NA' at the
end...When i changed that to 'BS' after i deployed it, the value in the
browser was BS...
So my question, how do i get the business intelligence to do the actual
day over day calculation??And if any more info is required, let me know

Thanks in advance,