OCUM 7.1 Custom Reports

[GTNDADABO]

Greetings,

Does anyone have some sample reports or instructions for creating a custom report for OCUM 7.1?

The Admin guide runs you through setting up eclipse and creating data sets but glosses over the actual creation of SQL queries.  As I'm not a SQL pro this is the part I really need.

[rolfh]

I posted a Vido explaining how to create reports including a template. https://www.youtube.com/watch?v=IcyZbjcs-sE&t=3s

[CompressionQuic]

Hallo,

thank for creating this Great Clip! May I ask you to Share the link for the Template file again? The Provided Link Seems to be Not valid Anemone. Thanks in advance.

regards 

Matthias

[rolfh]

Hi

The link to the template should still be valid: https://dl.dropboxusercontent.com/u/324207336/Netapp/OCUMTemplate.rptdesign.

Regards, Rolf

[Mike_Pedigo]

Got it to work at the following link which was on the YouTube video:

https://www.youtube.com/redirect?q=https%3A%2F%2Fwww.dropbox.com%2Fs%2F1w2w9sfcbsrkqv9%2FOCUMTemplate.rptdesign%3Fdl%3D0&redir_token=Ot613qe1XunLlYz8p...

[Dhiman]

Hi,

Please use the TR: https://www.netapp.com/us/media/tr-4565.pdf as a guide for building your custom reports. The TR guides you through creating a custom report with some examples.

Hope this helps.

Thanks,

Dhiman

[udo_braunschweiger]

Hello Rolf

do you have an actual link for the file?

I get an error message when in click it!

https://dl.dropboxusercontent.com/u/324207336/Netapp/OCUMTemplate.rptdesign.

Thank you!!

Kind Reagrds Udo

[Mike_Pedigo]

The following link works or see my post above:  https://www.youtube.com/redirect?q=https%3A%2F%2Fwww.dropbox.com%2Fs%2F1w2w9sfcbsrkqv9%2FOCUMTemplate.rptdesign%3Fdl%3D0&redir_token=Ot613qe1XunLlYz8p...

[gmilazzoitag]

Hi!

I think I've followed the instructions with no errors: I've got the connections, I can browse from dataset the categories and so on.
Then I've tested the sample query in the video but my testing preview give me the colums with zero result.

What is going wrong?

Thanks a lot

[rolfh]

HI

Hard to say without your query. But If you get all the database fields under available items in the query window, your datasource is set up correctly.

If you get no error but empty fields, you should look at the "join" and "where" statements. If no values return, the error might be there.

Regards,

Rolf