How to call functions in the Report

[sjoysuresh]

Hi,
I have 3 dimensions
1)Product which has four levels
2)Sector which has three levels
3)Classification which has 2 levels

I have a calculated member which is based on the level of my dimensions.
Say product level = 1
Sector Level = 2

I need to pass values dynamically to a function(user defined in SQl Server) based on the level

How can I accomplish this?

Kindly suggest.Thanks in advance

With warm regards,
S.Suresh

 

[Sridharan]

Whats the basic funda behind this ??? If you have a Function designed at the DB Level then you should be able to call that as part of the SQL by defining the object appropriately at the Designer Level. AFAIK I don't think you can call a function from the BO Reporter. You are out of luck here.

Sri

 

[sjoysuresh]

Hi,
The basic funda is i am display measures which are based on some calculation for weighted average.
So for each level of drilling I need to calculate the measures.
In other words the measures are non additive

 

[deaco]

if worst comes to the worst you could do some vba behind the report to run the function on the dbase.