Hi All,
We have a dimension structure as follows:
Dimesnion Name-
1. Calendar
-Year[level 1]
-Month [level 2]
2. Business
-Enterprise Id[level 1]
- All OG [level 2]
- OG [level 3]
-CO [level 4]
3. OG
-Enterprise Id[level 1]
- OPGRP [level 2]
- Client [level 3]
- Eng [level 4]
- Con [level 5]

Now I have to Select the month as the default member in the reporting tool
(DSP-Decision Support Panel) based on the "current month key" which is a
member property of business dimension's CO[level 4]. I get user information
in the form of domain\username and I have to remove domain name from this
string.

Can some help me finding out the mdx expression for this requirement.

Thanks in advance.

---------
Ashish Tiwari

Removing domain from the user information is simple. For example,

Mid( UserName, InStr(1, UserName, "\") + 1, 128 )

If the member name is comparable, next kind of expression can be considered.

StrToMember(StrToMember(Trim(Mid( UserName, InStr(1, UserName, "\") + 1,
128 ))).Properties("CurrentMonthKey"))

Ohjoo

"Ashish Tiwari" <AshishTiwari (AT) discussions (DOT) microsoft.com> wrote

Thanks Ohjoo,
I was using a similar expression, i.e.
Filter({[Calendar].[Month
Nm].Members},[Calendar].CurrentMember.Properties("Month Key") =
[Business_Unilever].[LCase(Mid("_DOMAIN_USERNAME_",InStr("_DOMAIN_USERN AME_","\")+1))].[All Outsourcing].[AO/IO].[AO].Properties("Current Month Key")
But it doesn't work when I use it in our DSP tool, it doesn't remove the
domain from the enterprise id ("_DOMAIN_USERNAME_" gives the logged in users
enterprise id).

Any idea, suggesions....

---
Ashish Tiwari


"Ohjoo Kwon" wrote:

I don't know DSP. I guess "_DOMAIN_USERNAME_ functions as UserName MDX
function does. Right?

By the way, there is things strange in your expression. Next is not right
syntax.

[Business_Unilever].[LCase(Mid("_DOMAIN_USERNAME_",InStr("_DOMAIN_USERN AME_","\")+1))].[All
Outsourcing].[AO/IO].[AO].Properties("Current Month Key")

Full string must be completed before it is converted to Member. For example,

StrToMember("[Business_Unilever].[" +
LCase(Mid("_DOMAIN_USERNAME_",InStr("_DOMAIN_USERN AME_","\")+1)) + "].[All
Outsourcing].[AO/IO].[AO]").Properties(("Current Month Key")

I hope this could help you.

Ohjoo

"Ashish Tiwari" <AshishTiwari (AT) discussions (DOT) microsoft.com> wrote