on 06-03-2010 6:14 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.