Creating and Viewing SAP BusinessObjects Contexts in IDT (Information Design Tool)

Creating and Viewing SAP BusinessObjects Contexts

Problem:

The Customer has multiple fact tables and wants to reuse the dimension tables without aliasing all the dimension tables or creating loops

Solution:

Create contexts for each fact table

Open up the Information Design tool (IDT) and within the IDT open up the data foundation layer

Creating_and_Viewing_Business_Objects_Contexts_1

From within the DFX layer if IDT select Aliases and Context

Creating_and_Viewing_Business_Objects_Contexts_2

Add a new context and name the new context

Creating_and_Viewing_Business_Objects_Contexts_3

Select the newly added context and you can now edit the context joins in two ways graphically or by viewing the individual joins. We will start by viewing the joins graphically and selecting edit

Creating_and_Viewing_Business_Objects_Contexts_4

Select the newly added context and you can now edit the context joins in two ways graphically or by viewing the individual joins. We will start by viewing the joins graphically and selecting edit

Creating_and_Viewing_Business_Objects_Contexts_4

Tip: Webi can be complicated. Our expert SAP BusinessObjects consultants can help. See how or contact us.

Now select the joins that you want in the context Green + is in the context and Red – is not in the context

Creating_and_Viewing_Business_Objects_Contexts_5

Verify graphically or by the individual joins that all the joins are in or out of the context, let’s view the individual joins to make sure that all our joins that we want to include or exclude or properly marked

Select the up arrow to switch the view at the bottom of the screen

Creating_and_Viewing_Business_Objects_Contexts_6

Now you can verify the joins

Creating_and_Viewing_Business_Objects_Contexts_7

Now we must go back into the other context to verify that the additional joins for the now context are not in the existing context. This can be accomplished by selecting each individual context and checking the Join Expressions

Creating_and_Viewing_Business_Objects_Contexts_8

Now that we have verified the contexts, we can save the DFX layer and republish the Universe.

SAP BusinessObjects Consulting Services »

Get Started

Want a FREE on-site discovery session with your team?  Receive a FREE data management evaluation session with one of our veteran data architects. Reap the benefits of an expert’s outlook on taking control of your business insights and data. Stop missing out on data-driven opportunities,  and start making smarter, more profitable decisions today.