Skip to Content
avatar image
Former Member

Drill with Key and Description

Hi Expert,

I have created a webi report at top of OLAP Universe ".UNV".

In the Universe I have created a hierarchy to navigate from Customer to Material.

How I can show the material key and description after the drill from Customer?

Thanks.

BR

Andrea

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 19, 2015 at 02:28 PM

    on universe you have to create one extra object like

    obj_material = materail_key + ' ' +materail description

    (concate the two objects)

    Now create custom hierercy with parent as customer and child as obj_material

    Just drag both the object to your report and go to drill now you can drill from customer to material key and description.

    Add comment
    10|10000 characters needed characters exceeded

  • May 20, 2015 at 11:18 AM

    Hi Andrea ,

    In Universe create new dimension with the Material Key attribute and use it for drill down in report.

    Add comment
    10|10000 characters needed characters exceeded