differences between list of values in data foundation and business layer

[Former Member]

we have list of values in both data foundation and business layer. what is the difference between both of them.any one pls... my gmail:soumyasreddi@gmail.com

[Former Member · Accepted solution]

Hi,

A data foundation LoV is inherited in a business layer and connot be edited in the business layer.

A business layer LoV is not visible in a data foundation.

A data foundation LoV can be based on:

• Static values
• Custom SQL

A business layer LoV can be based on:

• Static values
• Custom SQL
• Business Objects

Here is a table describing which objects support which type of LoV:

	List of Values Based on Business Layer Objects	Static List of Values Objects	List of Values Based on Custom SQL Objects
Data Foundation
Join	N/A	Supported	Supported
Calculated column	N/A	Supported	Supported
Derived table	N/A	Supported	Supported
Parameter	N/A	Supported	Supported
Relational Business Layer
Dimension	Supported	Supported	Supported
Attribute	Supported	Supported	Supported
Measure	Supported	Supported	Supported
Parameter	Supported	Supported	Supported
Filter	Supported	Supported	Supported
List of values	N/A	N/A	N/A
Multidimensional Business Layer
Dimension	Supported	Supported	N/A
Attribute	Supported	Supported	N/A
Measure	Supported	Supported	N/A
Named set	N/A	N/A	N/A
Calculated member	N/A	N/A	N/A
Analysis dimension	N/A	N/A	N/A
Hierarchy	Supported	Supported	N/A
Level	Supported	Supported	N/A
Filter	N/A	N/A	N/A
List of values	N/A	N/A	N/A

Didier

[Former Member · Accepted solution]

thank you but i am asking about porformance base

[former_member193452 · Accepted solution]

Static values would be the best for performance.

The IDT does not cache list of values so any option of SQL would be executed.

I don't believe there is a performance difference between the two layers.  Just wheterh the SQL is run vs the static values.