If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

EP 8.3 Publish only gets numerical values, no text

Started by wentriken, 09 Nov 2011 03:57:29 PM

Previous topic - Next topic

wentriken

I am publishing all E-list items in a View-based publish. The result is that I only see the numeric values. For example, we have a text field in Planning called Customer Name, and that doesn't show up anywhere. Does this publish to a different place?

Also, is there documentation on the output of this publish process? I saw a DBA guide for version 7, but it does not seem to match the database structure I have. Specifically, 7 seems to have a denormalized view out of the box. We are creating a custom query to denormalize (although it is pretty straightforward).

Rutulian

Hi Wentriken,

I'd seriously consider taking a look at the Table publish if you don't already have legacy systems feeding off View-based.  View-based is pretty much deprecated since 7.3, all the tweaks in the newer versions are usually focused on Table then occasionally backported to View.  Table publish will give you a nice clean star schema which should be easy enough to build the views you want on top of...

R

wentriken

SORRY, I asked wrong. We have done a table publish, in the star schema format. Then we manually put together the denormalization query, apparently incorrectly. Do you know if there is documentation for this denormalization? Specifically we are only seeing the numeric values in the table, no text values.

wentriken

More detail. Running this:

select table_name, column_name from all_tab_columns where column_name like '%CUSTOMER%'

Gives no results. The main dimension includes Customer Name as a text field as well as Net Revenue as a number field. When running

select table_name, column_name from all_tab_columns where column_name like '%REVENUE%'

There are plenty of fields.