Creation of Structures in BOBJ

[Former Member]

Hi All,

we have a requirement to display a report in first region wise, personnel area wise, then job wise only to some restricted values. Is it possiblt to create these restricted structures in BOBJ side. I think in Universe designer , it is possible to create this by a new class. But i am not clear . Please explain.

Thanks ,

Praveen Kumar

[amrsalem1983 · Accepted solution]

whats your source?

is it SAP BI Query?

you can restrict data as you want using filters in the universe

but you can not create any new structures

good luck

[Former Member]

Hi ,

Thanks for the reply. The above document specifies only how to set the filters or conditions. My requirement is to cretae a structure as if like BEX. EX. The Job column has values from 01 to 20... The values 01 and 02 should be combined into one column value and should be displayed as "Associate", values 05 & 09 should be combined and displayed as " Analyst" , values 10,11,12 should be combined and displayed as "Consultant" and the remaining values not needed for the report. Please how to do this in Universe level.

Thanks and Regards,

Praveen Kumar

[Former Member]

Hi

You can create new object under a new class or old class as per requirement and do then under statement you can write a sql code.

Same can be done in Webi too as it's not recommended to do calculation on universe layer if required.

As far as code , you can use this :

=If([dimension] InList("01";"02";"06")) Then "text displayed" ElseIf([dimension] InList("03";"04")) Then "text displayed"

For structure , you need to see the tables as joins between the tables comes into play.

But it's possible.

Edited by: akhanna1 on Jan 4, 2011 1:43 PM

[former_member142702]

This can only be done either at report level or at BEx query level if you use an SAP BW OLAP universe.

Regards,

Stratos

[Former Member]

Hi ,

Thanks for ur Quick reply. my source is Bex Query. I dont want a restricted key figure in universe. I want to restrict the characteristic(dimension) for the results. In my Bex Query already i have a restricted key figure headcount. My columns in the webi report should be REGION, PERSONNEL AREA, JOB, HEADCOUNT. Our requirement is to fetch only the values for US in region column , some fixed personnel area always. In Bex we can do this by creating a structure for the characteristics in the rows side . But my question is to how to do this in BOBJ side, i dont want to do in BEx side. Is it possible to create a sub class for region and populate only the required region values?

Thanks and Regards

Praveen Kumar

[former_member142702]

You can add a filter in the universe (check the document I referenced above on how to do that for SAP BW universes) that restricts the appropriate characteristic to US.

Of course you can create a new class for your key figure/dimension objects (insert also the filter in this class) and set the filter properties to be applied automatically for the class objects.

The advantage of this approach is that your users will not have to care about anything when they build their own WebI reports since the filter will be applied automatically when they use the objects from the specific class.

Still it may be confusing for them when they combine objects from the US class with objects from another class in their query since the restrictions will be applied as long as one single object from the so-called US class is choosen.

Regards,

Stratos

[former_member142702]

Assuming you are fetching data from SAP BW and that you are using BO XI 3.1 SP3 I would recommend to look at the following document:

http://help.sap.com/businessobject/product_guides/boexir31SP3/en/xi31_sp3_sap_olap_univ_en.pdf

It describes the way to define your own filters at universe level. You can apply those filters for every query or for a query containing object from a specific class. This is not exactly how restricted key figure work on the BEx side since adding a single object from a specific class will apply the filter on the entire results even if other objects reside in non-restricted classes.

In this case you can add 3 separate queries in your WebI report each one fetching results by applying a different filter.

Abother approach is to fetch all unrestricted results in your WebI report wiht a single query and apply local report filters on report blocks (eg. tables or charts) in order to display the data as you want.

BTW your requirement to display results region wise, personnel area wise and then job wise sounds to me that you will have to group your results in webi in different ways.

Regards,

Stratos