ReportNet architecture

[dpreston10]

Does ReportNet use Cubes on the DB or does it need a standalone db for the queries?

Thanks
DDP

[cognosfreelancer]

Ahh, you will get a Consultant's answer.

It depends.

ReportNet 1.1 MR2 by itself cannot query against a cube, that will come in ReportNet 8. For now it can query only against the DB.

However you can integrate Powerplay 7.3 content into a ReportNet report creating one integrated report.

HTH
Regards
NKT

[Robert]

And perhaps it's possible to connect to a cube by using excel. Don't ask me for the details, I want to try it myself also...

[Darek]

Theoretically it could, even before Series8 comes out. You can leverage Cognos Web Services (CWS) to access a PPES cubes and present it's data as an XML document, which can be added as an XML data source to ReportNet. It does not give you to much OLAP functionality though.

[cognostechie]

Cognosfreelance...We recently went on Repornet and the guy from COGNOS who came to give us the demo did insert a cube into Reportnet and made a report from that and that was version 1.1 MR2.

[Darek]

But the report you saw was a PowerPlay Report. What dpreston10 is looking for I believe, is having a cube as a data sorce available in Framework Manager, Query Studio and Report Studio. Not availble directly in CRN 1.1 MR2.

[cognostechie]

Does ReportNet use Cubes on the DB or does it need a standalone db for the queries?

Thanks
DDP

Did you mean cubes that are a collection of database tables (Dimension and Fact Tables)? If that's what you meant, sure Reportnet can query on that as that is not technically any different than any other DB tables, or did you mean Powerplay cubes (.mdc files).

[Darek]

Correct. Tables fine. MDC not.