3 Replies Latest reply on Jun 15, 2017 6:13 AM by SaQ-Orcl

Create Report - Catalog Manager in OBIEE12C

1877648 Jun 13, 2017 9:54 AM

Hi !

[OS - Windows 8 | OBI Ver - OBIEE 12.2.1.0.0] [ Using Catalog manager in offline mode]

Problem :

It is about Catalog Manager Create Report utility.

The output is not getting saved in Excel format even after selecting the Excel option.

When you explicitly try to save the file in xlsx or csv format, the output in the file being saved is not separated by any delimiter.

It just that all the result is either in one line or a column. I mean the data is not delimited by comma or tab.

Am I missing anything ?

Regards

1. Re: Create Report - Catalog Manager in OBIEE12C

Venkata Rachuri Jun 14, 2017 8:19 PM (in response to 1877648)

Did you try to change the extension manually to .xlxs and try to open using excel? what happened?

I agree everything is coming in single column
Like Show 0 Likes(0)

Actions
2. Re: Create Report - Catalog Manager in OBIEE12C

1877648 Jun 15, 2017 5:28 AM (in response to Venkata Rachuri)

Yes, I tried it but it fails to save the data in proper format, I mean data being shown was without any deliminator.
It's like all the file data gets saved in a single row and column. Something like that.
Like Show 0 Likes(0)

Actions
3. Re: Create Report - Catalog Manager in OBIEE12C

SaQ-Orcl Jun 15, 2017 6:13 AM (in response to 1877648)

Hi @1877648

Seems you dont have excel driver. Please open in other server where excel is installed.

Thanks
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.