Sap Analytic Cloud Application Design - How to fill a dropdown by data source dimension?

[michaelwecker]

Hello,

does somebody know how to fill a dropdown within SAP Analytic Cloud Analytic Application

I understand that you have to fill it on onInitialization.

My try was:

var product_list = Table_1.getDataSource().getMembers("Produkt");

Dropdown_Produkt.addItem(product_list, product_list);

How is the syntax for

addItem(key: string, text?: string);

Thank you for your support

Best regards

Michael

[joyal_laj]

Hai,

Can we enable search inside a similar dropdown having dimension values?

Thanks and Regards,

Joyal Laj

[TammyPowlas · Accepted solution]

Michael - it is not active in my tenant yet, but here is the on init code we used in a workshop recently:

var i=0;
var ListDimensions = Table_1.getDataSource().getDimensions();
for (i=0;i< ListDimensions.length; i++)
{
Dropdown_2.addItem(ListDimensions[i].id,ListDimensions[i].description);
}

Hope that helps.

[joyal_laj · Accepted solution]

Hai,

Can we enable search inside a similar dropdown having dimension values?

Thanks and Regards,

Joyal Laj

[TammyPowlas · Accepted solution]

Hi - as this is a closed thread, please create a new question at answers.sap.com - thank you

[michaelwecker]

Hello Tammy thank you for your quick answer.

The code you delivered was almost right I just changed

var i=0;
var productlist = Table_1.getDataSource().getMembers("Produkt");
for (i=0;i< productlist.length; i++)
{
Dropdown_Produkt.addItem(productlist[i].id,productlist[i].description);
}

Thank you very much.

Best regards

Michael Wecker

[sarthaksrivasta]

Hello Michael Wecker,

Do you know how to get aggregated value of a measure like this?

is there any function to access measure values as you accessed dimension values using getmember() ?

I have raised the question here:

https://answers.sap.com/questions/12748297/add-measure-value-in-a-text-box-in-sap-analytics-c.html

Thanks,

Sarthak Srivastava