cancel
Showing results for 
Search instead for 
Did you mean: 

OLAP Caching question

Former Member
0 Kudos

Hi

I'm not sure if this is the right forum, but I figured I would ask anyways. Using the broadcaster, I have configured a couple variable settings on a query to fill the OLAP Cache.

Is there a way to update the parameter settings by an api instead of going in manually to each query and updating the parameter values?

For example, say I want to cache only two months worth of data. I set the query settings for Jan and Feb. Now I want to configure to Mar and Apr. Instead of manually opening up the settings and entering and saving I want to do this using code if possible.

The reason why is if I have 100 queries to set this, it would be much easier to run this through code than manually updating the values.

Thanks in advance,

Daniel

Accepted Solutions (1)

Accepted Solutions (1)

Pravender
Active Contributor
0 Kudos

You can create variables in TVARVC or RSRVARIANT table and use them in query. When you will save a query variant then you will get options to choose variables. You have to write a code/program to update the values of these variable to reflect the latest value.

former_member185181
Active Contributor
0 Kudos

check the table RSRPARAMETRIZA, field-content which stores the variant values. You can update the variant values dynamically using ABAP.

This articles shows you how to do that.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f048c590-31a4-2c10-8599-bd01fabb93d4

Former Member
0 Kudos

Thanks to the both of you for your responses.

Much appreciated.

Daniel

Answers (0)