SmartView 11.1.2.3 – 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.

Advertisements

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 MondayBI.com 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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s