Author Topic: CWM to Cognos Framework Manager without OLAP option  (Read 135 times)

0 Members and 1 Guest are viewing this topic.

Offline h2obubbler

  • Full Member
  • *
  • Posts: 228
  • Karma: +0/-0
  • Life is like a box of chocolate.
    • View Profile
CWM to Cognos Framework Manager without OLAP option
« on: August 15, 2008, 07:14:21 AM »
Hi guys,

So here\'s my story. Basically, we are currently starting out on a project and our star model was done via Oracle Designer. Now is there a way to bring it into OWB 10g Release 2 and create the dimension with some underlying tables in it? This is my dilemma at the moment.  I guess ETL mapping into dimensions is much easier than making it into the table. The same principle goes for cube designing where I can define the level of the dimension. If i do this properly for sure things would become easier when we move to a multidimensional OLAP. All the mapping can stay the same because we\'ll be using the dimensions to map into. The other reasoning to use dimensional modeling in OWB is to maybe test report development with Oracle Report, Dashboard and JDeveloper.

Once the design is complete, I would like to export from OWB the CWM metadata and import the output into Cognos 8 Framework Manager. I\'ve read some blogs around and others says that Framework Manager doesn\'t have to worry about the underlying tables; ie: if we change from star schema tables to snowflake tables (for time dimension) or multidimensional tables in Analytical Workspaces. Can Cognos still take advantage on my OWB Collection import of dimensions and cubes? Do i need to install OLAPSYS Schema but not turn on the OLAP Option? How about the need for Java API\'s ? Can someone elaborate me on this as im really confused on the matter.
Many Thanks.

Techronnati | where technology never sleeps

CWM to Cognos Framework Manager without OLAP option
« on: August 15, 2008, 07:14:21 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
133 Views
Last post September 15, 2008, 01:59:25 AM
by MoneyRepublic
0 Replies
1587 Views
Last post November 27, 2008, 02:04:38 AM
by MrSpecialist
1 Replies
94 Views
Last post August 07, 2014, 01:02:15 AM
by rpmolecule
1 Replies
106 Views
Last post August 21, 2014, 03:32:53 AM
by Transformer10
0 Replies
41 Views
Last post November 16, 2016, 11:10:07 AM
by arpee

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.