Skip to Content
author's profile photo Former Member
Former Member

How to View Data

Greetings gurus,

I'm working through DS Tutorial and ran a job (for WF, DF) to import data from SALES_ORG.TXT into SALESORG_DIM.

The job completed successfuly and the attribute said 3 rows were loaded.

But when I goto the SALESORG_DIM to View Data, it found no data.

Where do I need to look?

I appreciate your insight.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Posted on Feb 12, 2009 at 09:19 AM

    edit: wrong questions asked by myself

    Edited by: Werner Daehn on Feb 16, 2009 11:00 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2009 at 04:55 PM

    Thanks for your reply.

    I'm using Oracle 10g.

    I can see the data using SQL Select Statement against table SALESORG_DIM, but I cant view the data using the DS Designer.

    What's missing?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 19, 2009 at 11:18 PM

    I can see the data by executing SELECT statement in SQLPLUS at the DOS Prompt.

    But I cannot view the data within Data Services.

    Does any BOBJ Gurus know what I'm missing?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      does your datastore have multiple configurations ?

      if yes, what is the configuration that you used to execute the Job ? set the same configuration as default configuration and the n check if you are able to view the data ?

      do you get an error ? or empty rows in the view data window ?

  • author's profile photo Former Member
    Former Member
    Posted on Feb 20, 2009 at 05:35 PM

    I defined the Target Datastore as Oracle database type/connection and accepted the default configurations.

    When I select the Target table (CUST_DIM) and choose Properties/Attributes, the log says there were records inserted and no erorr.

    If I choose the View Data tab, I see no data, just a blank gray sub window.

    Do I need to explicitly tell it to populate this target table in Data Services even though I can see the contents of that table using SQL at the DOS Prompt?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      DI doesn't store data in its repository, it will read the data from the table using the connection information from the Datastore

      can you try following options

      1 - Open the dataflow that is using this table as source or target, on the source or target you will see a magnifying glass icon click on that, does this diaplys the data ?

      2 - Right click on the table from the datastore and click on View Data

      The view data page, again has few more tabs,click on the Data Tab, its the first tab, the other tabs are for displaying profiling data, if no profiling is done you will see a gray window

  • author's profile photo Former Member
    Former Member
    Posted on Feb 20, 2009 at 07:16 PM

    I've followed your suggestions but still the gray subwindow.

    My Profiler Server Localhost is not running. What is the Profiler Server Localhost? Is that why I'm not able to view data?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      view data has nothing to do with Profier Server, the data is read directly from the database not through proflier server

      are you getting any ocx control not registered warning or error when you designer ? do you any other installation of Designer wher you can check this

  • author's profile photo Former Member
    Former Member
    Posted on Feb 20, 2009 at 10:32 PM

    I didnt get any error executing the Job.

    When I installed Data Services on my machine, I had to exclude all the "Server" related components in my installation.

    The system admin created a login account for me with my own local data respository.

    Any help would be greatly appreciated.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2009 at 03:38 PM

    Hello--

    I'm not certain whether re-installing the DS (Client) or renaming the registry from "settings" to "settings1" hlep fixed the problem, but it works now.

    Thanks for everyone's help.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.