Author Topic: ReportNet architecture  (Read 1338 times)

Offline dpreston10

  • Associate
  • **
  • Posts: 1
  • Forum Citizenship: +0/-0
ReportNet architecture
« on: 27 Jul 2005 02:27:52 pm »
Does ReportNet use Cubes on the DB or does it need a standalone db for the queries?

Thanks
DDP

Offline cognosfreelancer

  • Global Moderator
  • Community Leader
  • *****
  • Posts: 218
  • Forum Citizenship: +19/-0
Re: ReportNet architecture
« Reply #1 on: 28 Jul 2005 06:51:24 am »
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

Offline Robert

  • Associate
  • **
  • Posts: 3
  • Forum Citizenship: +1/-0
Re: ReportNet architecture
« Reply #2 on: 04 Aug 2005 06:00:22 am »
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...
Change is the only constant value

Darek

  • Guest
Re: ReportNet architecture
« Reply #3 on: 04 Aug 2005 09:44:45 am »
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.

Offline cognostechie

  • Statesman
  • ******
  • Posts: 753
  • Forum Citizenship: +55/-0
Re: ReportNet architecture
« Reply #4 on: 05 Aug 2005 02:55:27 pm »
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

  • Guest
Re: ReportNet architecture
« Reply #5 on: 05 Aug 2005 03:45:22 pm »
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.

Offline cognostechie

  • Statesman
  • ******
  • Posts: 753
  • Forum Citizenship: +55/-0
Re: ReportNet architecture
« Reply #6 on: 05 Aug 2005 04:09:48 pm »
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

  • Guest
Re: ReportNet architecture
« Reply #7 on: 05 Aug 2005 04:19:18 pm »
Correct. Tables fine. MDC not.