Hi,

I am using Oledb with MSOLAP provider for returning results of MDX query
to the .Net environment. My question here is that as i can change the caption
of Measure columns which are returned from the MDX query, is it possible to
change the caption of Fixed columns also in the MDX statement? I tried lot of
things but nothing turned out to be successful.

Thanks
Deepak Vij

You could always create a calculated measure whether in MDX or directly into
the cube to do this for you.

For example, if you have a measure called [Measures].[UserDCount] which you
want to return as User Distinct Count, then you could always create a
calculated measure within OLAP that is basically
member [Measures].[User Distinct Count] as '[Measures].[UserDCount]'

or within the MDX the same thing:
with
member [Measures].[User Distinct Count] as '[Measures].[UserDCount]'
select {
[Measures].[User Distinct Count]
} on columns, {
....

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"Deepak Vij" <DeepakVij (AT) discussions (DOT) microsoft.com> wrote

Hi Denny,

First of all, thanks for the reply.

You are correct while saying this for measures. but i actually wanted a
query for Fixed columns, the column which are created by 'On Rows'
specifications.

Hope this makes sense now. please let me know if you want any other
information regarding the same.

Regards,
Deepak Vij

"Denny Lee" wrote:

Hmm - are you referring to the name of the dimension (in the header row) in
this case or are you referring to the actual dimension members that show up
in the row listing? If you want to change the latter (the dimension
members), I would probably create a virtual dimension based on a member
property that has the member names you want to have (AS2k) or a new
attribute and/or hierarchy for AS2k5. If its the name of the dimension, you
could use the caption option in AS2k5 but you don't really have an option
for AS2k. Could you clarify this a little bit more? Thanks!

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"Deepak Vij" <DeepakVij (AT) discussions (DOT) microsoft.com> wrote

Very true. I want the change the caption of dimension itself. Can you please
provide me some guidance to do the same?

Thanks
Deepak Vij

"Denny Lee" wrote:

Does somebody know about this?

Thanks in advance,
Deepak Vij.

"Deepak Vij" wrote:

Hi Deepak,

How are you doing? Do you know something about this issue?

Thanks
Deepak Vij.

"Deepak Vij" wrote: