Skip to Content
0
Former Member
Apr 29, 2015 at 02:00 PM

Key value pair in webi

142 Views

Hi,

We have a report which generates the query as

Fact_Aggregation_View fv

Inner join Dimension1 d1 on d1.key=fv.key1

Inner join Dimension2 d2 on d2.key=fv.key2

where d1.name='XX'

and d2.desc='YY'

The where clause filters values(XX and YY) come from user selected report prompts. I want to change these filters to use the keys instead of values coming from the prompts. Something like Key/value pair and also I want those keys to apply to fact key columns (fv.key1, fv.key2) and not Dimension keys(d1.key,d2.key). The reason is that unless filters apply to view directly, the view takes a vary long time to complete. If keys are applied at DB level then view completes in a min.

Kindly suggest.

Cheers

Jim