Hello all, my first post here!
I have inherited the SAP BW HR system. I know very little about SAP BW. I have tried searching on this subject but have not been successful.
My scenario is this:
In the system there is a hierarchy for cost centres. Organisation changes has meant that some departments are moving areas and therefore have an end date under one area and a new start date in another area.
eg Dept A moves from Area 1 to Area 2 on 01.MAY.2010
Area 1 Dept A (01.01.1000 to 30.04.2010) Dept B (01.01.1000 to 31.12.9999) Dept C (01.01.1000 to 31.12.9999) Area 2 Dept D (01.01.1000 to 31.12.9999) Dept A (01.05.2010 to 31.12.9999)
We have no development area so we are we limited in trying things out. What we did do was copy the hierarchy and made changes as required then created a new query based loosely on a production query to see if the departments moved to the correct area when the date of the query was changed.
That proved successful when querying only on a month, though it seems when there is a date range that crossed the date of changes it picks only the newest structure.
My questions are these:
1) Can the orginal hierarcy be amended and if so, will any queries built around this hierarchy automatically pick up the new changes? Or do we have to create a new hierarchy and amend all queries to use new hierarchy?
2) When there is a date range ie. 03.2010 to 05.2010 should the query not show as: Dept A shown in both areas? When we try it, Dept A only shows in Area2
What I think it should be
===================
AREA ...DATE.. Count
Area 1
Dept A 03.2010 1
04.2010 1
05.2010
Dept B 03.2010 1
04.2010 1
05.2010 1
Dept C 03.2010 1
04.2010 1
05.2010 1
Area 2
Dept D 03.2010 1
04.2010 1
05.2010 1
Dept A 03.2010
04.2010
05.2010 1
What it shows
============
AREA ...DATE.. Count
Area 1
Dept B 03.2010 1
04.2010 1
05.2010 1
Dept C 03.2010 1
04.2010 1
05.2010 1
Area 2
Dept D 03.2010 1
04.2010 1
05.2010 1
Dept A 03.2010
04.2010
05.2010 1
I hope my scenario and question are clear!
Any information or help is very much appreciated
Rich