cancel
Showing results for 
Search instead for 
Did you mean: 

Process Dimension Log file

Former Member
0 Kudos

Hi

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

Thanks

View Entire Topic
sorin_radulescu
Employee
Employee
0 Kudos

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