Hi all,
I have a hard time finding information about the SAP module "Real Estate". I'm currently selectively activating business content, but we are not too happy about the SAP standard solution.
The SAP solution is to load data straight into a cubes, which will need to be emptied before loading.
But that aside,
In our design data/infosources 0REFX_2 and 0REFX_7 are loaded into an ODS each and I wish to build a cube on top of the 2 ODS's with the inflow-outflow principle. The 2 datasources only give the changes (plusses and minuses) so it would be perfect for inflow-outflow.
How do I define an inflow-outflow based keyfigure, when I only have an inflow keyfigure and no outflow? (0MEAS_CHG for example only give the changes, +30, -15, +50, etc.)
Does anyone know where I can find a white paper regarding inflow-outflow?
Thanks,
Eduard
Hi Eduard / Everyone, Can u please send me the design document to my email soniyakv@hotmail.com or suggest the approach to include the ODS for 0REFX_2 AND 0REFX_7 and I want to know what to put in key field and what to put in data field for an ODS design for real estate.
Thanks
Soniya
Hi,
I have finished the REFX design and it seems to work fine. It's now on the test-system and will be transported to production soon.
In a nutshell:
The report show the available floorspace (gross and nett), the floorspace available for renting and the floorspace rented out.
I have created 3 ODS's and 1 infocube.
ODS 1: On top of BC datasource 0REFX_2, key = real estate object, valid from
ODS 2: On top of BC datasource 0REFX_7, key = real estate object, valid from
ODS 3: Also on top of BC datasource 0REFX_7, additive and key = real estate object
ODS 3 does not have the 'valid from'-date in the key for a specific reason: 0REFX_7 does not supply data until 31.12.9999. When a lease contract ends, no data is supplied with occupancy = 0 for this real estate object. So if a contract ends on 30.09.2006 and you run a report for october 2006, you will no see data. We use ODS 3 to create a 0-record from the end of the last contract + 1 day until 31.12.9999.
Basically, because the 'valid from'-date is not in the key and the ODS is set to additive, loading a full load into ODS 3 shows you the total amount that is rented out for each real estate object. This data is then loaded into ODS 2 with the key figures * -1 (setting the leased out space to 0).
This way, every real estate object will have records up until 31.12.9999, which allows reporting on periods after a building has made unavailable for rent. Having additive keyfigures also means that the ODS needs to be emptied before loading.
The cube is also emptied before loading and is filled by ODS 1 and 2. There is only one keyfigure which has a different meaning depending on the 0MEASTYPE (gross, nett, available for rent, occupied). This key figure is a 'Non-cumul. value change' key figure based on 0MEAS_CHG.
This also needs to be taken into account met making a query (create a calc keyf with exception aggregation for calenderday)
A bit of a quick overview, but I hope this'll give you some ideas.
Cheers,
Eduard
Hi Soniya,
I do not have any SAP documents. That was my problem too and I posted here to find something, but never got a response. REFX is obviously not a widespread application. I basically used the SAP library (help.sap.com) to find info on the datasources and experimented with 'Non-cumul. value change'-keyfigures myself.
Regarding the activation of datasources, I had problems replicating aswell, because I was replicating the wrong REFX-part. There is "Real Estate Management" and "Flexible Real Estate Management", both in different nodes in the datasource tree. Did you try to replicate both?
Cheers,
Eduard
PS, how is BI 7.0? What are the major improvements over 3.5 that are really valuable/handy? We're evaluating upgrading, but we won't upgrade until we really know if the benefits outweigh the trouble of upgrading.
Soniya,
I have not used 0REOBJECT as a masterdata object, so there is no datasource for it in my design. 0REOBJECT is a field delivered by the 0REFX_2 and 0REFX_7 datasources and it's basically a concatenation of 0REOBJTYPE + 0COMPCODE + 0BUSENTITY + 0REBUILDING. A very long infoobject, perfect for using as key in an ODS. But there is no neccesary masterdata to go with it that you can load with 0REOBJECT_ATTR. Instead, I use the masterdata of 0REOBJTYPE, 0COMPCODE, 0BUSENTITY, 0REBUILDING for my queries.
My ODS's basically follow the Bus. Cont. datasources 0REFX_2 and 0REFX_7 one-on-one.
So, in short, I use these datasources:
- 0REFX_2 (TRX data for ODS1)
- 0REFX_7 (TRX data for ODS2)
- 0REBUILDING_ATTR & TEXT (masterdata)
- 0BUSENTITY_ATTR & TEXT (masterdata)
- 0REPROPERTY_ATTR & TEXT (masterdata)
- 0RENTOBJECT_ATTR & TEXT (masterdata)
- 0OBJ_COND (texts)
- 0MEASTYPE (texts)
- 0REOBJTYPE (texts)
- 0RENTTYPE (texts)
Hope that helps...
Eduard
Sorry Babu, I have no knowledge of an Oracle solution for RE. When a company is already a SAP user, it would be obvious to go for the SAP solution over the Oracle one, wouldn't it? It would be a maintenance nightmare if every ERP module had it's own system.
cheers,
E
Hi Eduard, Please help every one on this in BI 7.0. I have a requirement to bring 0fiscper and 0VAC_PER cube ZMAP_1 which is same as ZREFX_C02.
Cube ZMAP_1 has standard mapping to infosource and datasource 0refx_2. now since 0fiscper and 0VAC_PER are missing in 0REFX_2 ,I am trying to bring the fields from
0refx_5 but when i create the transformation from cube cube ZMAP_1 to infosource 0refx_5 it ask me to map 0calday field in cube but there is no valid from or 0calday field in infosource 0refx_5 so i try mapping 0fiscper with 0calday which ofcourse will not work. please suggest now in steps how to proceede, since i have very simple requirement to bring 0fiscper and 0VAC_PER in cube ZMAP_1 by creating the mapping from datasource 0refx_5.
please help with the steps in BI 7.0
thanks
Regards
Soniya Kapoor
i HAVE THE 0MEAS_VALUE Key figure which is non cumulative in my ods, but when i try to map that to infosource it does not show up in transformation. the how will i map that TO ECC Field " 0meas_value"
Please help me.Please correct me if this is not right I am using Valid to and Valid from and 0reobject as Key field in ods.
Thanks
soniya
Add a comment