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: No events within the next 45 days.

[BOBJ 5.x] Deski Report


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
Rob_mot
Forum Member
Forum Member



Joined: 28 Jan 2019

Posts: 7


flag
PostPosted: Wed Mar 20, 2019 7:30 am 
Post subject: Deski Report

Hi Experts,

Could you please let me know how can I populate some objects in the report?

I am having below error massage.

"Variable is not compatible with the other variables in the block."

I have four queries and two Universes. I have linked the common objects as well but still I can't add those objects in the report.

Please help!
Thank you.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11364
Location: Manchester, UK


flag
PostPosted: Wed Mar 20, 2019 7:36 am 
Post subject: Re: Deski Report

Hi Rob.

The simple answer is "it depends".

You can relate things as long as they should be related.

For example, if you sell cars and motorcycles, you wouldn't report on Number of Doors against motorcycle sales.
Similarly you could have monthly budget data from one universe and sales data from another and as long as there is an equality of objects to merge you will be fine.

What's your scenario?

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Rob_mot
Forum Member
Forum Member



Joined: 28 Jan 2019

Posts: 7


flag
PostPosted: Wed Mar 20, 2019 9:36 am 
Post subject: Re: Deski Report

Thank you Mark for the reply,

I want to populate addresses in to the report. I have found the addresss in both the universe and linked it as well. But still I am having the error.

Thank you for your time.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11364
Location: Manchester, UK


flag
PostPosted: Wed Mar 20, 2019 1:34 pm 
Post subject: Re: Deski Report

Which variable are you having problems with? If there is only one dimension on one side that is a problem and it has a one-to-one relationship, you could create a Detail variable as, for example,
=[Dimension Name]

Then use this detail instead of the dimension.
If it gives a #MULTIVALUE error then it isn't a one-to-one relationship.

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Rob_mot
Forum Member
Forum Member



Joined: 28 Jan 2019

Posts: 7


flag
PostPosted: Thu Mar 21, 2019 7:15 am 
Post subject: Re: Deski Report

Thank you ever so much Mark,

I will try this.

Regards.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  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.0301 seconds using 17 queries. (SQL 0.0028 Parse 0.0009 Other 0.0264)
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