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).
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
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.
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.
SOLUTION AT http://www.cognoise.com/community/index.php?topic=13207.msg41698#msg41698