If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Event Studio Condition on Contributor Data

Started by EP_explorer, 27 Aug 2009 09:04:49 AM

Previous topic - Next topic

EP_explorer

First of all Can I use Contributor Data as Condition for Event Studio?

For example - User Input a number in a specific cell of a Contributor cube - Event Studio compares the number with a condition and lauch a macros.

When I open Event Studio with the Contributor application I see it structure - Cubes, dimensions but I have no idea how can I use it.

For example. I have one D-cube Calculation with 2 D-list ABC1 (with 3 elements A, B, C), Zn (with one element Zn) and e-list (with one element Test). I want to make rule which launch the macros if User enter 10 in element A.

How I can write the condition?

Is it sort of ([Calculation].[ABC1].[A];[Calculation].[Zn].[Zn];[Calculation].[e-list].[Test])=10

Or it is impossible?

I don't have Framework Manager. Version - Planning 8.4


EP_explorer

This document describes how to use database data as source to Event Studio. But I use data of Contributor cells.

Actually I solved this problem. Thanks for everybody.

praveennb

Quote from: EP_explorer on 09 Sep 2009 04:56:54 AM
This document describes how to use database data as source to Event Studio. But I use data of Contributor cells.

Actually I solved this problem. Thanks for everybody.

It would be helpful if could share your solution

EP_explorer

Actually, it is very simple if you know how to do it. But it is strange why there aren't any solutions on IBM cognos site.
ok.

You open a package in Event Studio. you see the list of cubes. You open the cube which data you want to use as a source for event. You see several dimensions and one dimension looks like the list of measures. I don't know the idea why one dimension is transformed in list of measures. Sometimes one dimension is transformed to the list of measures in another case - another.

After it for each dimensions you drug and drop Member Description to list of expression and set the value. For measures you drug and drop measure and set the value for it. If you want to see the calculation of the Member Description you can go on list of calculation.

At the end you receive the next sort of expression:
[E]=500 AND [Member Description]=('Test') and [Member Description1]=('A') where E is measure and 500 is value in Contributor cell which we want to use as condition. 'Test' is an element of d-list for first dimension, 'A' is an element for second dimension for D-Cube.

in calculation you can see:
E : [ABCE1].[EC].[Examination].[Calculation2].[Calculation1].[E]
Member Description: [ABCE1].[Znachenie].[Znachenie].[Member Description]
Member Description1: [ABCE1].[ABC3].[ABC3].[Member Description]

How you can understand I used D-Cube ABCE1 with D-lists: EC, Znachenie, ABC3
and D-list EC was tranformated to the list of measures

Moreshwar

Can you please elaborate on this as i am confused about specifying event studio condition on the Contributor Grid Data. I want to run a macro if the value in the contributor grid is changed.

thanks for all your support
moreshwar

francois

#6
You'll need an access to the containers database + a
publish table of the application in the containers db.

Build a framework package based on something like the following :
one table with datasource query :
select b.displayname as elist, c.displayname as estatus, a.statedatetime
from my_appli_container.dbo.nodestate as a
inner join my_appli_table_container.dbo.it_Elist as b
on a.nodeguid=b.itemid
inner join my_appli_table_container.dbo.workflowstateenum as c
on b.stateid=c.stateid

add to the package a table based on the et_tables of your application db, create the link between them in FM using elist iids and you'll get something gathering both status and values.

use your framework to create an event condition based on elist item status or value.