Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Using Excel as a data source in Business Intelligent Publisher

Received Response
11
Views
3
Comments
JCD-user
JCD-user Rank 1 - Community Starter
in Oracle Business Intelligence Applications Forum

HI,

We are trying to build a data model in Business Intelligent Publisher using a query and an excel spreadsheet. The query and and spreadsheet joined by an id. However, when we obtain data, the data coming from the spreadsheet are incorrect. Can you please help us? Please let me know if you need the screenshots, query or the spreadsheet. Thanks.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod 
    JCD-user wrote:when we obtain data, the data coming from the spreadsheet are incorrect.

    How can you say it's incorrect? Publisher does what you tell it to do.

    So maybe you can double check how you configured your sources and the join and make sure what you got is actually the right data.

  • JCD-user
    JCD-user Rank 1 - Community Starter

    Hi,

    The data model is showing the same Impression ID for all furniture furniture. We are expecting to see specific impression ID for each furniture. Please see the attached screenshots.data_model.JPGimpression.JPG

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    You've got different data types between your keys TAB_ID and TABID ...