Which table stores Measures information in BPC 7.5 MS version

[Former Member]

Hi Experts ,

Currently i am working on SAP BPC 7.5 MS version  with SQL data base backend.

In SAP BPC NW version i know that measures is stored in UJA_FORMULA_APP” table  but i have following doubts

1.In which table does measures information stored in BPC 7.5 MS version?

2.Steps to identify this table in SQL Database of BPC 7.5 MS version?

Thanks in advance,

Siva

[former_member244885 · Accepted solution]

In the MS version it's the FACT tables.  The FACT tables are partitioned in to a write back table, a FAC2 table, and a Fact Table.  For example if you have an app named, "app" you'd have the following 3 tables:

tblFACTWBapp

tblFAC2app

tblFactapp

The reason for the three tables has to do with performance, pre-calculated OLAP cube data, and the built in optimize package including the packages various levels of processing (lite/full).  tblFACTWBapp stores non-optimized data, tblFAC2app stores lite-optimized data, and tblFactapp stores the full-optimized data.