SmartView – Find Members Limitation

I know I said that I write something about Essbase, but recently I came across a problem with SmartView. I just want you all to know about it so that everyone can go around it.

My SmartView is connecting with Essbase ASO or BSO, it’s gives the same problem. As you know, you can find members with SmartView. And as you all know asterisk ” * ” can be used behind a string as a wildcard. So you can find “West Sales” by typing “We*”.

Now, the problem with SmartView is that when in your Dimension, if you have asterisk as an Alias then you will not be able to search through the hierarchy. Instead, it’ll always return the first member that has the asterisk. Moreover, I find that I encounter the same problem even when the hierarchy contains a member that has pipes ” | “. Interesting though, I can’t find this in documentations.

I’m not sure if this is a bug, but I think we should skip these characters for now. Please do feel free to comment if you ever come across the same problem.


Author: Steve Yeung

Being in the EPM & BI field for more than 8 years, it's about time I contribute to newcomers! As a founder of I wish to give you all the help I can. Feel free to give any suggestions or questions. Hope you will all enjoy this blog! William Wong Essbase Certified Specialist OBIEE Certified Specialist

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: