BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Column shows blank even when data is populated


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
ben1233
Forum Member
Forum Member



Joined: 02 Mar 2010

Posts: 2



PostPosted: Tue Mar 02, 2010 11:56 am 
Post subject: Column shows blank even when data is populated

Hi All....first time poster on the bob. Thankfully, I'm a first time poster because I'm always able to find answers to my questions without having to post a question! Thanks to all....

I currently have 2 separate universes that both have Oracle 9 connections. There is one view in each universe. Both views are essentially identical except they point to different databases. (Hence the 2 universes; one contains US data, the other has Brazil data.) There is a particular column in both views, but when I do a right-click->table values, the column shows up blank in the US universe. I also tried doing a right-click on the actual field name and did a "distinct column values" and the only thing I get back is one blank row.

Now, the odd thing is if I connect to the database using Toad I see many rows that have numeric data populated. Furthermore, the Brazil universe is working just fine and shows many rows with populated values.

I checked the DDLs (or IALs) for both view definitions and indeed they are identical. My version of Designer is 11.5.0.0. We are running XIR2 SP5 FP5.2.

Is this a BO Designer problem? Or is this a problem on the backend within Oracle? Anyone ever run into this? Help me Rhonda!
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14246
Location: England


flag
PostPosted: Tue Mar 02, 2010 12:02 pm 
Post subject: Re: Column shows blank even when data is populated

Welcome to Bicon_mrgreen.gifB!

Just asking the obvious, but if you write a simple BO query on the problem universe, I assume it doesn't show you any data...even though if you were to take the sql and bung it into TOAD it does show you data?
Back to top
ben1233
Forum Member
Forum Member



Joined: 02 Mar 2010

Posts: 2



PostPosted: Tue Mar 02, 2010 1:58 pm 
Post subject: Re: Column shows blank even when data is populated

Correct, if I run a simple report in webi (which gives me an entirely blank column) and take that SQL to TOAD, I indeed see data in the 'problem' column.

I also tried making a free-hand query out of this report and still, no data in BO.

thanks for the help...
ben
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14246
Location: England


flag
PostPosted: Wed Mar 03, 2010 3:00 am 
Post subject: Re: Column shows blank even when data is populated

Sounds bonkers. I'm guessing new objects won't make any difference. Is the universe connection as you would expect it?
Back to top
JdVries
Forum Associate
Forum Associate



Joined: 06 Feb 2006

Posts: 717
Location: The Dutch Mountains


flag
PostPosted: Wed Mar 03, 2010 9:40 am 
Post subject: Re: Column shows blank even when data is populated

ben1233,

Think about:
1 The maximum numer of fetched rows defined in the universe.
2. Virtual private database (Oracle).
3. Same user in TOAD and BO?

Hope this helps,
Johan

_________________
Forcasting is very difficult, especially where it concerns the future.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0290 seconds using 18 queries. (SQL 0.0028 Parse 0.0009 Other 0.0253)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo