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

[Former Member]

I don't believe such a log file exists, on BPC 5.1.

Easiest way to check is to process a dimension, then search on the application server for files modified in the last 5 minutes or whenever you processed it.

[Former Member]

We are having a problem processing dimensions.

When I try to process the account dimension, it says - Skip Optimize Schema and then Fail.

Is there anyway to analyze why this is happening?

Thanks

[Former Member]

Hi Maverick,

Are all the applications using Account dimension optimizing fine? Try optimizing all applications and try porcessing dimension again

Kranthi

[Former Member]

Hi Kranthi,

Yes I optimized all the applications. Did not get any error.

[Former Member]

Check if the hierarchies are defined properly. You can take a copy of dimension and remove the hierarchi and try processing only on the base members first n then update parent cols. You can't have same parent member in say parenth1 n parenth2

kranthi

[Former Member]

I checked and everything seems to be correct. Raised an OSS too.

Is there anywhere I can analyze what the process dimension is doing exactly?

[Former Member]

Restarted the server .. and it worked !!.. The dimension processed just fine and EVDRE is ok too !!

Strange.. but I don't care

[former_member599120]

Dear Maverick Explorer,

I never find the log file and I only use the "BPC System Reports" in the BPC Web. You will see all log such as: activity, BPF, comment, data, work status, security, etc.

Thanks,

Wandi