Hyperion Essbase (MOSC)

MOSC Banner

Problem with SubString in Hyperion

edited Sep 5, 2019 3:19PM in Hyperion Essbase (MOSC) 3 commentsAnswered

Hello, ok im having a problem with the function Substring. As far as i understand this function allows me to get the data of the id from a member.

In the next example im trying to get the data of the current member in my table so in smart view i can see that data. For example, for the member of Entity i hava "E0455" so when i use Substring, 1, 5, i expect to get the result "0455" but instead of that in my smart view all i get is "0" as a value in all my members, and i dont know why this is happening, is something wrong with my syntaxis ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center