Process Dimension Log file

[Former Member]

Hi

Can someone tell me where I can find the log file that is generated upon processing a dimension?

Thanks

[sorin_radulescu · Accepted solution]

Usually the problem is coming when you have data into fact table with member from dimension which doesn't exist any more into that dimension.

You have to run a selection like that to check the intergrity of data from fact table:

select * from tblfact"nameofyourapplication" where "yourdimensionname" not in (select [id] from mbr"yourdimensionname" where calc = 'N')

if this selection return any rows then you have to delete these rows replacing select with delete.

Of course you have to do this verification for all dimensions from your application.

Kind Regards

Sorin Radulescu