Facttables "source" column.

[benniejayfguevarra]

Hi dear experts,

I was just wondering, if why is there a source column in the fact tables?

i hace looked on the BPC help but i cant find answers.

Thanks, in advance.

Benniejay

[former_member1192543 · Accepted solution]

Hi,

I did't get your qestion..can you explain it correctly and be specific to domain or technology like BPC5.1 or 7.0 or BI e.t.c.this will hep us to give you a solution..

Hope you understood the prob...

Regards,

Naresh.K

[i045436]

As this is an internal usage of BPC, it was not documented, as I know.

[Former Member]

Hi,

Value of 1 might also land you in errors like"send governor failure" .Pls do check to ensure that 0 as the value in 3 tables

regards

shyam

Edited by: Shyam Sundar Rajendran on Apr 30, 2009 11:01 AM

[i045436]

When Source=1 means that a lite optimize is working. If this value staying to 1 more time it is something wrong (maybe a lite has crashed).

[former_member1192543]

Thanks Mihaela,

I was little confused on this earlier.now i got the idea.can i find any doc on this in SDN or help files,any where...

Regards,

Naresh.K

[benniejayfguevarra]

Ow, okay. Thanks.

I've just got the question because one time when i look at the fact tables , because usually it only contains 0, i've seen that its value is '1'.

okay. Thanks Michaela.

[i045436]

Hello,

The Source column is used internally the the product when is doing lite optimize, fulloptimize. Should not be touch. The Source<>0 means data is moving to other fact table.

Best regards,

Mihaela

[benniejayfguevarra]

Hi,

Its on BPC 5.x and on other versions.,

Facttables are the tables where they stored data that is used by OLAP to process the aggregated data.

in BPC there are 3 facttables.

tblFactCubename, tblWBFactCubename, tblFAC2Cubename.

and the columns on each tables are the dimensions on each CUBE.

now, my question is what is the use of the Source Column on the FactTables?

Thanks,

BennieJay