cancel
Showing results for 
Search instead for 
Did you mean: 

Missing Dimension Hierarchy

Former Member
0 Kudos

Hi all

We have experienced a problem over the last couple of days where a dimension hierarchy has seemingly vanished from the BPC web front end.

The structure of our hierarchies is transported through our DEV / QA / PROD landscape and appears in QA in the BW backend as below:

However, in PROD it appears in the backend as below:

As you can see, PARENTH3 is missing from PROD.

We tried running UJA_REFRESH_DIM_CACHE and UJXO_CLEAN_DIM_CACHE but without success.


For a day, PARENTH3 could be seen in the BW backend but not the web front end.  I tried to 'Activate' the hierarchy from the backend but this resulted in the entire dimension being unusable (could not save) and stopped people logging into the system!  I edited the structure of the erroneous hierarchy and saved a small change which corrected the problem.  However, PARENTH3 was now gone from the back end as well as the front.

I am planning a transport of the dimension to replace the missing PARENTH3.


Has anyone seen anything like this happen before ?

Ian

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Lan,

Check the master data you are maintaining in dimension for PARENTH3 hierarchy in PROD system.The hierarchy you are not seen in BW just because  of missing master data in dimension .I thing it's good if you are maintain hierarchy manually  in 3 landscape, if there is no special restriction are applicable.  



Khokan

Former Member
0 Kudos

Hi Khokan

Yes, I can see the master data in the BW PROD system.  However, I cannot see any trace of this hierarchy information in the web front end system.

Normally, the refresh dimension program solves similar cases to this but we have not had it before with a dimension missing.

Any other thoughts ?

Ian

Former Member
0 Kudos

Hi lan,

Problem is that BPC don't activate the second hierarchies in the BW-backend by default, after transporting the dimension and hierarchies may be the member are not maintaing in prod system for this particular hierarchy, by the way in which dimension you are using multiple hierarchy and your BW version?



Khokan

Former Member
0 Kudos

We are 7.3.

The hierarchy was working fine last week, then over the weekend it vanished from BPC front end.

Transport restored this but why did this happen ??