hadnling contexts in VBA Macro

sdk development
1

Hi ,

i am back with a VBA Query…

I have a report which has a Context. Now when refreshing the report using a VBA , Is there any way , I can handle thecontext in VBA…I mean is there any option thru which I can select the context.

Thanx,
Vikram

vikram_new (BOB member since 2004-10-04)

2

Hi can anyone please help me

:roll_eyes: :cry: :frowning:

vikram_new (BOB member since 2004-10-04)

3

If you want to select a particular context, then you could (possibly - I’ve not tried it) add another condition using vba that will force the query down a particular path of joins.

Just curious - are you working against an OLTP or DW database? If Data Warehouing, if you are selecting a measure from a fact table, then the contexts should be sorted out for you anyway. What’s the scenario where you are having trouble?

4

Hi Marc,

We are having a DW. ERcently there some cahnges were made to teh universes which resulted in creation of some new contexts.

Now, these contextx appear in most of the reports. We have some reports in the following manner:

We have an Excel sheet through which we connect to Busines Object, refresh the report and the data is populated into the Excel sheet.

Now if we have contexts here, How do I choose a particular context? is there anyway I can hardocde the context in the VBA macro wirrtin in Excel?

Thanks

vikram_new (BOB member since 2004-10-04)

5

To my knowledge, there is nothing in the object model that lets you specify a context. As previous posts have suggested, you should focus on the universe itself and how the contexts are defined. As long as a fact table is included in the query, there should be no prompt for context.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

6

Hi,

Thanks for the reply.

Anyway, i shall look into the scenario again and get back.

Thanks

vikram_new (BOB member since 2004-10-04)

7

Hi,
I am intereseted too in this matter. We’re trying to automate the testing phase for our universe and we’re running many scenarios.If the context prompt appears something is wrong :? . Is there a way in VBA for Bo XIR2 to handle or detect this ?
Thanks

andreiv (BOB member since 2009-11-16)