function with a Cellset as parameter?

Hi all,

I want to create a function (Analysis Servieces 2005) that expects a CellSet as Parameter, but I don't understand very good how to pass A Cellset to a function.
I have the next Code that should return my CellSet:

SELECT NON EMPTY{ [Measures].[InvoiceAmount] } ON COLUMNS, NON EMPTY { ([Buyer].[Company].[Company].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM
( SELECT ( { [Com Device].[Com Device].["ComDevice"] } ) ON COLUMNS FROM
( SELECT ( { [Invoice].[Period Code].["PeriodeCode"] } ) ON COLUMNS FROM
( SELECT ( { [Seller].[Company].["Seller"] } ) ON COLUMNS FROM [Invoicing])))
WHERE ( [Seller].[Company].[Seller], [Invoice].[Period Code].["PeriodeCode"], [Com Device].[Com Device].["ComDevice"])

Any help is appriciated.

What sort of function do you mean?
Where would you want to call this function from?
What is this function meant to do?

|||

Hi Adam,

It is a .Net function, that should return a string as value.
the select query has 2 filter-values, I want the companies that had the "comdevice" in the given "PeriodeCode".
I am calling the function from reporting services.

Hope this clears it a bit.

thanx
PS.(Is it maby possible to excute the query within the function, It is a function within the db-assemblies?)

|||

Sorry, I'm still not clear as to why you want to do this. Why write a .NET function?

My understanding is that all you want is a parametrized MDX query. Is this correct? If so reporting services supports this.

Can you describe the problem you are trying to solve rather than the solution you are trying to come up with. Maybe there's an easier solution that can accomplish what you need.

|||

Thanx for your reply Adam,

I have the next problem:
I have a table in my report, that uses dataset "Comdevice". In that same table I show some Invoice-values per Comdevice.
What I want to do is show the company that bought this comdevice. I can't do this in the same dataset, because the company that bought the device is on "SALESLEVEL 300" and the invoice-values I show are on "SALESLEVEL 240". My function would be a temporary solution to this problem.
Sorry if the solution is very clear, but I'm very new to Mdx.

thanx in advance

|||I'm not sure what you mean by "SALESLEVEL 300" and "SALESLEVEL 240". To help me understand what you are trying to do could you please mock up the desired report layout in excel and then copy paste it into a post.