on 10-20-2015 12:22 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.