Skip to Content
author's profile photo
Former Member

Module "Real Estate, RE-FX"

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

8 Answers

  • author's profile photo
    Former Member
    Posted on Oct 25, 2006 at 09:25 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Oct 30, 2006 at 10:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi all,

      I was impressed by the design ideas on how to display the Real estate data.

      There has been a requirement to display

      - How many days is the rental object vacant

      - The from and to dates

      - To see if it is attached to a contract

      - if it is not occupied, how long has vacant

      Do the preexisting queries, delivered in business content answer these questions, or will a multiprovider across cubes be required to answer these.

      Any tips would be greatly appreciated.

      Thank you.

      Simon

  • author's profile photo
    Former Member
    Posted on Nov 02, 2006 at 07:01 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Edurad can u please reply to any of my open post so that I can give you points for the help. I want to know since there is no 0reobject_attr for flexible real estate how you have included 0REOBJECT IN CUBE AND ODS. HAVE U CREATE THE DATA SOURCE I KNOW THERE IS one in real estate but not in flexible real estate

      please help

      thanks

      Soniya

  • author's profile photo
    Former Member
    Posted on Nov 03, 2006 at 07:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Nov 07, 2006 at 12:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Nov 07, 2006 at 06:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Eduard, I have a requirement to bring the real estate measurement data and fixed asset and tax data from condition cube to generate the real estate Investment/market / tax value - portfolio overview report. all fields are available in different datasources

      is it possible that i create a multiprovider on top of 3 cubes fixed aset,measurement and condition cube and select the field char and key figure to meet the requirement

      OR

      i need to enhance the datasource of fixed asset to include the measurement information and push that to custom cube based on fixed cube to include measurement fields

      Please suggest the minimum requirement to build a multiprovider so that i can decide on approach

      please help asap

      Regards

      Soniya Kapoor

  • author's profile photo
    Former Member
    Posted on Nov 28, 2006 at 10:10 AM

    I'd suggest to make a multiprovider. Easier in maintenance in case you need to change anything later.

    Eduard

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      My cube has only 2 keyfigures:

      0MEAS_VALUE and 0MEAS_CHG.

      The info/datasources (0REFX_2 and 0REFX_7) deliver 3 key figures:

      <u>0REFX_2</u>:

      0MEAS_CAP_C, capacity change (dep on 0MEASTYPE gross, nett, free)

      <u>0REFX_7:</u>

      0MS_VAL_O_C, occupancy change

      0MS_VAL_V_C, available space change

      (These 2 are eachothers opposite)

      In loading the cube, 0MEAS_CAP_C and 0MS_VAL_O_C are both mapped to 0MEAS_CHG, and OMEAS_VALUE stays empty. (0MS_VAL_V_C is not necessary as it's the opposite of 0MS_VAL_O_C)

      The infoobject 0MEAS_VALUE is the NCum. Value with NCum. value change 0MEAS_CHG.

      In the query you have to make a calculated keyfigure based on 0MEAS_VALUE, with exception aggregation on the last value, based on 0CALDAY.

      Hope this helps.

      Cheers,

      Eduard

      PS, you might want to start a new topic about it, as this topic is still my question which has been solved already.

  • author's profile photo
    Former Member
    Posted on Dec 19, 2006 at 05:20 PM

    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 comment
    10|10000 characters needed characters exceeded