set function

[bajrang]

hi,
I know that set function Returns a list of members belonging to the same hierarchy
e.x set([Golf Equipment], [Irons], [TrailChef Cup])
but i want to use set with measure but it not work
set([revenue], [cost], [quantity])

thanks :)

[Prerna Chaudhary]

Hi,

Very true, Set is applicable only for the members that belong to the same hierarchy. But using this function for multiple measures like set([revenue], [cost], [quantity]) will not return any results. But in case you are working with dimensional data, you can use Tuples. Tuples also known as Intersection is useful for obtaining a value from the combination of two or more members that you specify. For example, the intersection (Revenue, 2004, Cooking Gear) shows the revenue value for the year2004 and for the product line Cooking Gear.

But it has certain limitations like:
1.Each member must be from a different hierarchy
2.The intersection can include only one measure

In cognos 8.4 and higher versions calculated members and measures can also be inserted in the tuple.

You can Insert a calculated member or measure into your report to add a new row or column with values that are based on a calculation. For example, you create a calculated measure named Euros that converts dollars to euros by multiplying an existing dollar measure by a conversion rate. Euros can then be displayed to end users in a separate row or column.

We usually Insert a calculated measure when the focus of the calculation is one or more measures and when you want the calculation to behave like a measure or to replace a measure. The expression used to define the calculation must not depend on the current measure context.


Please let me know if you need some further details upon the same.

Prerna
---------------------------------------------------------------------------------------------------
pchaudhary@infocepts.com | www.infocepts.com
---------------------------------------------------------------------------------------------------

[bajrang]

hi,

Actually I working on active report of cognos 10
So for radio button group  I need one dimension that contain these measure
All these measure from cube(dimensional )
set([revenue per year], [revenue per product line ], [revenue per country] []revenue chart)