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

Accepted Solutions (1)

Accepted Solutions (1)

sorin_radulescu
Active Contributor
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

Answers (2)

Answers (2)

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

Hi Maverick,

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

Kranthi

Former Member
0 Kudos

Hi Kranthi,

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

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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

Strange.. but I don't care

former_member599120
Contributor
0 Kudos

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