BPC fact table settings in BW

[Former Member]

Hi.

This is mostly a BW question, but indeed related to BPC, which is why I did ask it here.

In BW, when you create applications in BPC, there will be created two fact tables E and F in BW as a BW dictionary table.

This fact tables is by BPC created with the technical settings for logical storage parameters:

Data Class: DFACT

Size Category: 4 (expected data records 500.000 to 2.100.000)

Now my question is, will it do any difference to performance if we change the size category?

We do have around 30.000.000 records in our E-fact table.

Best regards

Mogens Smerdel

[Former Member]

Did you thought of Archive option in BPC ?

Regads,

Sonti

[Former Member]

Hi Raju and Sonti.

Thank you both for your responses.

Raju.

I already have the categories in my system. So I think I will try and see if it has any effect performance-wise switching to a higher category. Have you tried that?

Sonti.

No I did not think of the Archieve option. What is that?

Best regards

Mogens Smerdel

[Former Member]

For Archive, Go to Excel Interface, RunPackage>Company Folder>SystemAdministration(Package Group)--> Archive.

Give the desired dimension and data range.

Regards,

Sonti.

[Former Member]

Hi Sonti.

I thought that was only for archieving of audit data, which is not in use.

Do you know exactly what it does? The help doesn't seem to be very clear about that.

Regards.

Mogens

[former_member190501]

Hi,

It seems like by default system will create fact tables (both E&F) with size category as 4 for any type of application.

Search following note for more details.

Note 123546 - Extending the permitted size categories

Hope it helps...

regards,

Raju