Value List - Performance

[manojkulkarni]

Hi,

I need to create one straight table to show certain KPIs with comparison. To represent KPI's as dimension, I am using ValueList.

Need experts suggestion, is it good to use or is there any other method to showcase ?

[sunny_talwar]

There are ways to perform the ValueList functionality using an Inline Island Table, but not sure if there are any performance benefits there. I know with ValueList you are UNABLE to make a selection, but with inline you would be ABLE to make a selection.

HTH

Best,

Sunny

[MK_QSL]

If you use ValueList as Calculated Dimension or as an Inline Iceland table there would be no difference in performance.

Inline Load is only to avoid duplicate written statement of ValueList using nested IFs.

Valuelist with many values and data having millions rows will give you poor performance but If there is no alternative for showing KPIs except ValueList function, one can take risk using it...

OfCourse : as suggested by Sunny... Inline load will give you advantage of KPI selection.