OBIEE 11g cache analysis with different variables using agent

0
votes

I have an analysis with many result records (if I don't filter special column in that, I will get Max exceeded number of records error), so I used a PresentationVariable in my filter ( ex : MyColumn = @{MyPresentationVariable} ) now I want to create an agent to seed cache for this analysis , but I can not find a way to run it with all available values for "MyColumn" . For example MyColumn can have value between 2000 and 2017 and I want a way to run the agent 18 times, how can I do that ?

1
obiee

1 Answers

0
votes

So you basically want to populate the cache with more data than your Presentation Server allows for rendering?

Question: Why? Isn't that a rather clear sign that you should rethink what you are doing in the first place?