@Christian Berg, Logon is a column in SA System subject area. Read some blogs to use the SA System for non obi users as well. www.clearpeaks.com/.../emailing-reports-to-non-obi-users-using-ibots . ‎

@Christian Berg I created a new user and created his delivery profile manually . Now it sent an email. So it seems like something wrong with SA System ..

Dear Christian, Thank you so much for your reply. Have you checked the log files? Do they say anything specific? Which log i should check? Scheduler logs or Presentation services log? Those two i checked and couldnt find any issues. Are you sure the delivery profiles are correctly populated through SA System? I have logged…

Tried to deliver via conditional request(SA_System) . But still it is delivering in dashboard but not on email and completed status in job manager.

Hello All, Thank you very much for all your help. Issue sorted out by creating an aggregate table for customerwise monthly repayment data, and Now only one record exist per customer per loan. Thanx

We have to set totals for the non conformed dimension in RPD and when we take sum for the repayment and loan loan value will add up based on number of records in the repayment table for same loan? can it happen?

.. If i make dimension out of fact it will become non conformed dimensions and will trouble us in reporting layer.

Hello Emmanuel, didnt create the join in OBIEE yet. I was executing query only. I have filters such as payment date , loan date etc in fact tables.

Usually people who are working in obiee background would have worked and faced similar issues. So just a try here.