In OTBI report each employee have getting two rows but businees need only one row?

AjayKumar Maddipati · Jul 18, 2022 12:43PM

Summary:

Hi Team,

when i set order as per bussiness requiremnt i taken and suppress the columns then when i export into csv or excel and with out usiing formatted option it comes normal report with out apply above conditions.

Could please assit on ?

for formated way.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Bhaskar Konar · Jul 24, 2022 4:27PM

Hi AjayKumar Maddipati,

If you want all the formatting that you did in Report to show you in downloaded version then you have to use the 'Formatted' way and then download in excel or your preferred options.

If you use Unformatted / CSV then raw data will be downloaded irrespective of any format that has been applied in the Report.

Hope this help.

Cheers,

AjayKumar Maddipati · Jul 27, 2022 6:56AM

Hi Team,

In below report for each single employee takeing two rows but business need all in one row any possible ?

Thanks,

Ajay

Amrita Gupta-Oracle · Jul 28, 2022 10:33AM

Hi Ajay,

Try applying the a MAX() function on all the attributes apart from the employee number.

Regards,

Amrita.

AjayKumar Maddipati · Jul 29, 2022 5:45AM

Hi

@Amrita Gupta-Oracle ,

Thanks for reply.

I applied all columns but no change.

PFA.

AjayKumar Maddipati · Jul 29, 2022 9:19AM

Hi ,

@Amrita Gupta-Oracle ,

Thanks for help and sorted the issue when i apply the Max(Formula).

Thanks,

Ajay

Amrita Gupta-Oracle · Jul 29, 2022 10:51AM

Hi Ajay,

Yes, it needs to be applied in the column formulae itself. Good to know your issue is resolved.

Regards,

Amrita.

Oracle Transactional Business Intelligence

Categories

In OTBI report each employee have getting two rows but businees need only one row?

Answers