RE: SAP BI 7.0 implementation

[Former Member]

Hi experts...

I got two questions:

1. when you do hierarchy attribute change runs and change master data for particular infoobject.....

will the old data be displayed according old master data or will it be displayed according to new master data.

2. say 0customer attribute (i.e. master data) changes slowly every few weeks... I want relevant reporting to be displayed according to updated information. How to design this...

anyone...

[Former Member · Accepted solution]

Hi Vince,

When you load new data and do the attribute change run then that new data starts appearing in the reports with immediate effect.

Now in case if you want to track how that data was changed over the time then you can make it time dependent attribute or time dependent hierarchy.

The data in the report will be shown based on the key date selected in the query and the valid master data belonging to that key date.

Regards,

Durgesh.

[Former Member]

Hi,

Master data is always overwritten.

Genarally when we load master data, the new records will be in modified(M) version.

In report we will get the records which are active version.

To turn m version records to a version, we have 2 methods.

Activate master data: this will activate the master data.

Attribute change run: this will activate the master data. If any of the aggregates are using this info object, then this will update the new master data in aggregates.

If you know master data will change based on time, then you can make the info object as time dependent.

In this case, date to field will work as key field.

Lets take below example

Customer--

---

locationdate to----date from

ABC--

---

MNO-31.06.2011-01.01.2011

ABC--

---

PQR--31.12.2011-01.07.2011

now if you execute the report for aug month,then you will get location as PQR. So based on the date you select to execute the query you will get applicable data.

Regards,

Venkatesh