Skip to Content
avatar image
Former Member

how to populate a crosstab table from dropdown selection ?

I have a dropdown box and a crosstab table which is based on a hierarchy dimension.

In the Dropdown Box(DDB.FRUIT) with Hierachy item(TBL_FRUIIT_HIERARCHY):

----------------------------

Sour Fruit

Sweet Fruit

Bitter Fruit

Crosstab Table

Sour

+Citrus

      -Orange

      -Lemon

My question is how do i pass the value from drop down box to Crosstab table in the on event script.

if (DDB_FRUIT_HIER.getSelectedValue() == "Bitter Fruit") {

  DS_FRUIT.activateHierarchy("ABC1230__ABC1122");

  DS_FRUIT.assignHierarchy("ABC1230__ABC1122", "Bitter Fruit");

TBL_FRUIT_HIERARCHY.getSelectedMember("ABC1230__ABC1122").externalKey);

Not sure i am correct or not..

Regards,

Joseph

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 26, 2015 at 04:54 AM

    Hi Joseph,

    Have you tried using the following script in the On Select event of the Dropdown?

    if (DDB_FRUIT_HIER.getSelectedValue() == "Bitter Fruit") {


    DS_FRUIT.setFilter("ABC1230__ABC1122","HIERARCHY_NODE/0HIER_NODE/BF";

    }

    where BF would be the key of the Bitter Fruit member.

    Hope this helps.

    Regards,

    Anuraag

    Add comment
    10|10000 characters needed characters exceeded