Writeback Error - or bug?

#1

Is your where clause "dbo"."DW_Dim_Period"."Period_Type"
<> 'P&L' added to the insert or update statement which is
used to update your table?

My guess is that update happenes without useage of that
clause. If you manage to add it, it'll probably work
allright. On the other hand, using a separate view might
work as well, since (I think) with a view the where
clause remains on the table permanently.

HTH Lutz

Quote:

-----Original Message-----
I have a dimension called Period.

The original database table contain periods Jan (1)
through Dec(12) and additionally an extra period called
IB
(0)- as the starting balance. The table also has a field
representing quarters (Q1, Q2 etc). The IB (0) period is
included in Q1. This table is quite general so is used
in
several OLAP cubes. In order to make it as general as
possible I have also added a field called Period_type
where values might be 'General' or more spesific 'P&L'
for
the P&L reporting cube.

One of the cubes that uses this table is a budgeting
cube.
This takes advantage of the nice cube writeback
functionality, and is used for sales budgeting and
forecasting.

In order to filter out the IB (0) period (it's not being
used for sales budgeting of course), I have set up a
separate time dimension "Period_Budget" with a filter on
the original data-table in the dimension editor:
"dbo"."DW_Dim_Period"."Period_Type" <> 'P&L'

Now here is the problem:
When I do writeback on quarter on the sales cube from Q1
the values are spread over the periods as following:

Jan Feb Mar
8 4 4

This indicates that period IB (0) still is taken account
of in a stange way - even with the source table filter
on.
If I delete the row IB (0) everything is OK.
Any solutions (except from deleting the row - or setting
up a separate view)?

Thanks in advance
RE
Bjørn T

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Writeback Error - or bug?

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

Writeback Error - or bug? - 08-29-2003 , 05:18 AM