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: Upcoming Events: PGHBOUG: Oct 19.

How to make objects incompatible

Goto page Previous  1, 2
 
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
nisha_18
Principal Member
Principal Member



Joined: 10 Aug 2004

Posts: 147



PostPosted: Wed Mar 09, 2005 3:22 pm 
Post subject: Re: How to make objects incompatible

How can I make 2 objects(2 dimensions or 1 measure&1 dimension) coming from 2 different tables(they are not aggregate tables) incompatible.

Hope this is much clear than the question above.

Any help appreciated.

Thanks,
Nisha

[Moderator Edit - Duplicate post in this topic removed]

_________________
-Nisha
Back to top
Duff
Principal Member
Principal Member



Joined: 28 Dec 2004

Posts: 148
Location: Downingtown, PA



PostPosted: Wed Mar 09, 2005 3:36 pm 
Post subject: Re: How to make objects incompatible

Again, it sounds like a context issue, but I would need more information to be sure. Are you saying that two dimensions objects from different tables are incompatible, but all the other attributes in those tables are compatible? That would be pretty strange.
Could you explain the situation a little better? Maybe provide your Universe?
Back to top
nisha_18
Principal Member
Principal Member



Joined: 10 Aug 2004

Posts: 147



PostPosted: Wed Mar 09, 2005 3:58 pm 
Post subject: Re: How to make objects incompatible

Hi Yo,

I already have a universe in place and right now the objects are compatible but the users wants them to be incompatible.This is how it is:

ObjectA(dimension) from Table A
ObjectB(dimension) from TAble B

Right now if I run a report it gives me results.
SELECT
Table A.Column_name1,
TAble B.Column_name1
FROM
Table A,
Table B,
Table C
WHERE
TAble A.key = TAble C.key
and TAbleC.key1 = TAble B.key1

Now I have to make these objects incompatible..How do I do this?If you need more info,Please let me know

Thanks

_________________
-Nisha
Back to top
Duff
Principal Member
Principal Member



Joined: 28 Dec 2004

Posts: 148
Location: Downingtown, PA



PostPosted: Wed Mar 09, 2005 4:29 pm 
Post subject: Re: How to make objects incompatible

Hi Nisha,
I can give you a quick answer - You can define one of your dimensions as Aggregate Aware with only one Aggregate option, like...
@Aggregate_Aware(Table A.Column_name1)
that will force the report builder to look at Aggregate Navigation for the object. In Aggregate Navigation, you make Table A incombatible with ObjectB. Now all Aggregates in table A will be incompatible with ObjectB, including ObjectA.
But I don't think this is sound design and I don't think it's the root of your issue. But I hope it helps.


Last edited by Duff on Tue Mar 15, 2005 11:00 am, edited 1 time in total
Back to top
Anita Craig
Forum Groupie
Forum Groupie



Joined: 17 Jun 2002

Posts: 8541
Location: Palo Alto, California, U.S.A.


flag
PostPosted: Wed Mar 09, 2005 5:54 pm 
Post subject: Re: How to make objects incompatible

So, should you only be able to report on Table A - Table B at one time, and Table B - Table C at another? If so, it's like Yo was saying all along -- you then need two different contexts.
_________________
Anita Craig Image link
Institutional Research & Decision Support
Stanford University Image link
____________________
Search is Your Friendô
Back to top
nisha_18
Principal Member
Principal Member



Joined: 10 Aug 2004

Posts: 147



PostPosted: Mon Mar 14, 2005 3:50 pm 
Post subject: Re: How to make objects incompatible

Hi,

How can I determine that 2 different objects from 2 tables are being used in the same context or in 2 different contexts.Is there a method to determine that or should I just look at the universe(Becos I have almost 250 contexts in the universe)

Thanks,
Nisha

_________________
-Nisha
Back to top
Anita Craig
Forum Groupie
Forum Groupie



Joined: 17 Jun 2002

Posts: 8541
Location: Palo Alto, California, U.S.A.


flag
PostPosted: Mon Mar 14, 2005 4:12 pm 
Post subject: Re: How to make objects incompatible

nisha_18 wrote:
...Becos I have almost 250 contexts in the universe...

Wow! eek.gif Why do you have that many contexts?

_________________
Anita Craig Image link
Institutional Research & Decision Support
Stanford University Image link
____________________
Search is Your Friendô
Back to top
nisha_18
Principal Member
Principal Member



Joined: 10 Aug 2004

Posts: 147



PostPosted: Mon Mar 14, 2005 4:26 pm 
Post subject: Re: How to make objects incompatible

Hi,

I know thats a lot..This is a huge universe with almost 1000 joins.Anyways,I was thinking if I can make a measure from one table(not aggregate table) incompatible with a dimension(not from aggregate table) using the following syntax as told by Yo before:

Define Measure as @Aggregate_Aware(sum(nvl(decode(TableA.Column_name1, 1002, TableA.Column_name2,0),0)))

The same measure is defined as follows right now:
(sum(nvl(decode(TableA.Column_name1, 1002, TableA.Column_name2,0),0)))

And then set the TableA incompatible to the dimensions from TableB in Aggregation Navigation

It works if I do it in the above way...But Is this a good way to define incompatibility? I am just worried if I define incompatibility as above,would it effect any other tables/objects in the universe.

Appreciate ur response.

Thanks,
Nisha

_________________
-Nisha
Back to top
nisha_18
Principal Member
Principal Member



Joined: 10 Aug 2004

Posts: 147



PostPosted: Tue Mar 15, 2005 8:36 pm 
Post subject: Re: How to make objects incompatible

Any help appreciated regarding the above.

Thanks

_________________
-Nisha
Back to top
Duff
Principal Member
Principal Member



Joined: 28 Dec 2004

Posts: 148
Location: Downingtown, PA



PostPosted: Wed Mar 16, 2005 8:34 am 
Post subject: Re: How to make objects incompatible

The direct impacts of your change is -
Any objects that are aggregate aware and use TABLEA will not be compatible with ANY objects that you defined TABLEA to be incompatible with in Aggregate Navigation.
I noticed you said "Dimensions" (plural)
Quote:
set the TableA incompatible to the dimensions from TableB in Aggregation Navigation

You'll then need to make TABLEA incompatible with all the objects from TABLEB. If you want to make all the objects from TABLEA incompatible with TABLEB, you'll also need to make them all aggregate aware.
You also need to make sure you make them incompatible with any condition objects that use TABLEB.
The incompatiblilities set in Aggregate Navigation will only affect your objects that use aggregate awareness, and those objects that you set as incompatible.
Even though this may work, if you are doing this because two tables in your Universe can be brought together in a report query by including these objects, but those two tables are actually incompatible, then I think you should be using contexts to solve your problem.
Also - just an fyi - Aggregate Navigation needs to be maintained anytime there are changes to the Universe. If you are using Aggregate Awareness and you add an object, you have to check Aggregate Navigation and set the incompatiblility appropriately. Lets say, for example, that you use this method, then later down the road you create a condition object based on TABLEB. You need to remember to update your Aggregate Navigation for TABLEA. I'm not sure how it defaults, but any time you add an object, you need to check to be sure. Even if it's not from TABLEB. You don't have that problem if you use Contexts.
Back to top
nisha_18
Principal Member
Principal Member



Joined: 10 Aug 2004

Posts: 147



PostPosted: Wed Mar 16, 2005 2:34 pm 
Post subject: Re: How to make objects incompatible

Hi Yo,

Thanks a lot for your response. If I have to work this problem around using contexts,how do I go about it. I mean if I run a report using those 2 objects from 2 different tables,how do I know which context it is using and what do I have to change in the context.

Thanks,
Nisha

_________________
-Nisha
Back to top
Duff
Principal Member
Principal Member



Joined: 28 Dec 2004

Posts: 148
Location: Downingtown, PA



PostPosted: Wed Mar 16, 2005 3:39 pm 
Post subject: Re: How to make objects incompatible

Hi Nisha,
To determine the context(s), check this post >
http://www.forumtopics.com/busobj/viewtopic.php?t=17431&highlight=triangles
To change it, double click the context. That will bring you to the Edit Context dialog box. All the Joins in the context will be highlighted. just click the one you want to remove to un-highlight it. Then click OK.

A couple of things you should know -
If 2 objects are put on a report that are not in the same context, BO may still allow them to be put on the same report by building multiple queries. This is a setting in the Universe parameters > SQL tab > Multiple SQL Statements for each Context. Typically this is a good thing because it allows different Facts to be reported by conformed dimensions on the same report.

If you have any reports that currently use the Join in the Context that you are removing, it will change how the reports are built, so you'll have to test them. Of course, you would only be doing this ...
Quote:
because two tables in your Universe can be brought together in a report query by including these objects, but those two tables are actually incompatible
so you shouldn't have any reports using it.
Back to top
nisha_18
Principal Member
Principal Member



Joined: 10 Aug 2004

Posts: 147



PostPosted: Thu Mar 17, 2005 4:45 pm 
Post subject: Re: How to make objects incompatible

Thanks a lot Yo.That helps in solving my issues.This is a big procedure as we have tons of joins and tables.

Appreciate your help again.

Thanks,
Nisha

_________________
-Nisha
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 2 of 2 All times are GMT - 5 Hours
Goto page Previous  1, 2
 
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.0339 seconds using 17 queries. (SQL 0.0031 Parse 0.0010 Other 0.0298)
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