Hyperion Essbase (MOSC)

MOSC Banner

Check ASO cube for data and delete members whci have no data

edited Jan 3, 2017 11:32AM in Hyperion Essbase (MOSC) 3 commentsAnswered

We have a BSO cube (Ex:BSO1)  with has current month data and metadata , 3 (prod, lot,key )dimensions in this BSO1 and dropped and built each month  .We also have  a corresponding reporting ASo cube (ex: ASO1) Here we merge all the current month data and metadata , Because of this in the ASO1 cube 2 of the dimensions (lot and key) are rapidly growing in size . We are planning to create another archieve ASO cube (ex:ASO2) where we would like to trasfer all metadata older that previous year  and the Current cube ASO1 will only have previous year

Tagged:

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