This content has been marked as final. Show 2 replies
In OBIEE do we have an option to split the member name. For example "S124"
should be "124" and "S" should be ignored in the reports
A. In OBIEE we have two option,
The out put like 124
Use substring function -- substring(your column value from 2 for 4)
In OBIEE do we have an option to get all the Level 0 members (bottom of the
hierarchy). We cannot use Generation here. Please see the example
A. Can please explain some more extend with anothe example am not getting your requirement.
Hope that help's
Thanks for the reply.
Right or Substring function are not working on Essbase Dimension members.
We have a ragged hierarchy in Essbase. The dimension members in a hierarchy are not symetric. We have different levels in each Hierarchy as mentioned the example of previous post.
When you import the cube in OBIEE, it comes as Generations. However, we need to report on Level 0 Members of the Hierarchy.
Is that possible?