This content has been marked as final. Show 4 replies
I assume that your question is about Oracle-OLAP dimension attribute (and not Essbase).1 person found this helpful
You will have to come up with a custom front-end (web or windows) where you will enter (or change) the attribute value. Then behind the scenes, you will call DBMS_CUBE.BUILD procedure to update the attribute value for that dimension member.
Here is an example:
Dimension = 'ACC', Hierarchy = 'ACCHIER', Dimension Member = 'CM1' and we want to update an attribute value called "LONG_DESCRIPTION" for this member 'CM1'.
dbms_cube.build(q'! "ACC" USING (
SET "ACC"."LONG_DESCRIPTION"["ACC" = 'CM1'] = CAST('Custom Member 1' AS VARCHAR2),
MERGE INTO HIERARCHIES ("ACC"."ACCHIER") VALUES ('CM1', 'ALL_ACC', NULL),
The feature Nasar mention is also available as an OLAP DML call. Search for documentation on UPDATE_ATTRIBUTE_VALUE.
This is all available in version 220.127.116.11 and higher.
CALL UPDATE_ATTRIBUTE_VALUE(dim_member_id, attribute_name, attribute_value [, auto_compile ])
Edited by: David Greenfield on Nov 14, 2012 9:57 AM
Corrected UPDATE_ATTRIBUTE_MEMBER to UPDATE_ATTRIBUTE_VALUE
The DML call did work. Call is, UPDATE_ATTRIBUTE_VALUE. There is no function UPDATE_ATTRIBUTE_MEMBER.
Also, I used a call similar to:
"PRODUCT" USING (SET "PRODUCT"."LONG_DESCRIPTION"["PRODUCT" = 'ITEM_OPT MOUSE']
= CAST('Optical Mouse' AS VARCHAR2))
Worked like a charm!
Edited by: user7853353 on Nov 13, 2012 7:18 PM
Thanks for catching the UPDATE_ATTRIBUTE_MEMBER error. That will teach me to copy and paste from the documentation! I will correct my previous post for the record.