Current position:  Home > Default > RETRIEVE LOWEST LEVEL OF HIERARCHY (OMB+)

RETRIEVE LOWEST LEVEL OF HIERARCHY (OMB+)

Time:November 30
Advertisement
Hi all,
How can I get the name of lowest level in the primary hierarchy of a dimension through OMB+?
OMBRETRIEVE DIMENSION_TABLE 'SALES_REP' GET LEVELS
gives me following result:
LOCATION COUNTRY EMPLOYEE REGION DEPARTMENT
while the original hierarchy is like
REGION COUNTRY LOCATION DEPARTMENT EMPLOYEE
how can i retrieve 'EMPLOYEE' level?
regards,
Zahid Naseer
Advertisement
Hello Zahid,
You have to specify which hierarchy to use to get levels sorted top to bottom, eg:
OMBRETRIEVE DIMENSION_TABLE 'SALES_REP' HIERARCHY 'MY_HIER' GET LEVELS
will probably give you the expected result.
Regards, Hans Henrik

Cannot drill down from 2nd lowest level to lowest level of hierarchy

-0001-11-30

In my item master hierarchy, I cannot drill down from the 2nd lowest level (Product Class) to the lowest level (Item Detail). When I add another level between these 2 levels, then I can drill down from Product Class to this new level, but I cannot dr

Aggregation at the lowest level in the cube

2015-10-11

Hi guys I designed very simple test cube with one dimension (both MOLAP driven). The dimension PRODUCT consists of three levels: - Group - Category - Product_detail PRODUCT_SRC table to load PRODUCT dimension: PR_GROUP_NAME PR_GROUP_ID PR_CATEGORY_NA

How to return list of lowest level elements in a hierarchy given the node o

2015-10-11

We would like to return a list of the lowest level Elements in a Hierarchy from a given node of the hierarchy.  The level of the node that is given to us is unknown, but regardless, we need the ability to return the lowest level elements.  We are try

Oracle SQL query to exclude lowest 2 leaf levels in hierarchy

-0001-11-30

Hello! I would need to traverse the hierarchy so that I could exclude the 2 lowest levels in the query. For eg: Considering the case below the query should return 1, 3, 5, 2, 6, 14.               1                                   2         |       

Hierarchy drill down issue at the lowest level

-0001-11-30

Hi, In OBIEE 11.1.1.5 I face an issue with drill down to lowest level of presentation hierarchy (expanded by "+" in report). It happens only for combination of 2 dimensions presentation hierarchies in analytics report (parent-child organizationa

Lowest Level in Prod Hierarchy

-0001-11-30

Hi All, I have a situation wherein i have to get to the lowest level match of the product hirearchy for the best fit. I have a custom table which maintains Prod. Hier as part of the Key. I need to get down to the best fit of that to the lowest level

Modify Chart Legend Data Behaviour to show only lowest level of drill

2015-10-11

I have a chart with a legend in OBIEE 11g. When I click on chart data or legend it drills to the next level of the hierarchy which is what I want. However the legend show all levels of the hierarchy in the legend data like this: "Level 1"."

Lowest Level in APO DP Heirarchy

-0001-11-30

In APO DP, how would a charecteristic is identified or noted as the lowest level in a heirarchy. I mean, if i have a product heirarchy as Main Grp -> Sub Grp -> SKU and SKU is my lowest level, how do i inform APO about the same. While creating POS t

Need help on Consolidation at higher level of hierarchy

-0001-11-30

Hi gurus,                I have a scenario where in I need to load one cube from other cube. The first cube has geography stored at lowest level i.e. country level. I need to load data in other cube by consolidating at region level. Hierarchyu2019s a

Top 10 lowest level dimension members based on measure

-0001-11-30

Hi, I'm trying to create a condition with JDeveloper to show the top 10 dimension members based on a measure for the lowest level of the hierarchy, but doesn't work. All other conditions are working well, including top 10 dimension members in other l

Exluding lowest level dimensionmembers from a total report.

-0001-11-30

Hi, I know this thread might belong in the Discover part of the forum, but based on previous experience it seems that Discoverer for OLAP help is difficult to come by in that part. Also I think this quickly might end up with being a bit more OLAP tec

Promotion planning and lowest level KF

-0001-11-30

Hai,         The promotion key figure has to be the lowest level of detail, which means the KF has to be the lowest in the hierarchy. This means, I can only assign promotions at the lowest level? For example, a product called DOW white color soaps an

Lowest Level Call X64 and what need to be preserved?

-0001-11-30

Hi,  Our team- recently had a problem regarding a lowest level function in x64 bit machines in Windows - and what needs to be preserved in order to safely handle the event and pass it on to Windows Kernel. I am not too experienced in handling functio

Why would adf treetable expand all sometimes not expand the lowest level?

-0001-11-30

I have two treetables in an application. When clicking on Expand All for the treetable that has three rules, or levels of hierarchy, then all levels are expanded. When clicking on Expand All for the other treetable which has four rules, or levels of

My battery life at a full 100% charge is about 2 hours 22 minutes (backlight and key lights at lowest level). Should I go complaining to Apple or do I just need different software?

2015-10-11

My battery life at a full 100% charge is about 2 hours 22 minutes (backlight and key lights at lowest level). Should I go complaining to Apple or do I just need different software? I've only had my mac book since August 2011. The battery dies in 2 to

SYST: Tax Jurisdiction code at lowest level not transferred

2015-10-11

Dear Experts, I am getting the above error while Releasing the Billing document to Accounting. I have created a ZTAX - Manual Tax (for enterring VAT% manually). Created the Sales Order, Delivery and Billing. At the time of document releasing to accou

Components in the lowest level of costing structure in SO

2015-10-11

Hi, Could you please let me know is any function module to get  Components in the lowest level of costing structure in Sales order. Thanks, HarinathYes, you can manipulate your components any way you like. Becareful about the layout manager though as

How to confine various level of planning in to limited and lowest level of planning in DP by the users

2015-10-11

Hi Gurus, May I know the various methods to confine planning level at the lowest level and re-define the Primitive methods where  business currently uses in excel sheet and plans at all level into demand planning with a minimum and lowest level by wh

Error while mapping fact table to LOWEST LEVEL

2015-10-11

Hi While Iam mapping my fact table using cwm2_olap_table_map, map_facttbl_levelkey , Iam mentioning it has the lowest level of dimension table , it is throwing error . Will it only work for ET not for LOWEST LEVEL?. Infact Iam not storing the embedde