LEVERAGING STARGATE VIEWS
Improving User Experience through Stargate Views
I.Introduction
IBM Planning Analytics is a wonderful tool to work with if it is managed correctly. Although default settings might be enough to use Planning Analytics applications, there are various approaches by which Planning Analytics’s capabilities could be improved. One such approach is to leverage Stargate Views.
II.What are Stargate Views?
If a PLANNING ANALYTICS cube is densely populated and has lot of rules then chances are cube views associated with it will take longer time to open. To address this issue PLANNING ANALYTICS Stargate views could be leveraged.
Stargate view is calculated and cached view of a PLANNING ANALYTICS cube that is created when you browse a view using cubeviewer. As users browse cubes via cube viewer, these views are cached according to the selected title elements, rows and column. Next time a user requests same view, stargate view is fetched and negates the need for on the fly calculation resulting in markedly better performance. Stargate view contains only the data for defined sections of the cube and does not contain formatting information associated. Size of the stargate cube is directly proportionate to the number of elements on rows and column. So more the number of elements in rows and columns, more the size of the stargate view.
III. Mechanism behind stargate view creation:
To create/store stargate view, PLANNING ANALYTICS provides couple of settings called VMM(View Maximum Memory) and VMT (View Minimum Time).
1. View Maximum Memory(VMM):
This feature determines for each cube the amount of memory available for Views to be cached..The value of VMM is expressed in kilobytes. If no VMM value is specified, the default value is 128 kilobytes.
This parameter could be modified using }CubeProperties cube. The valid range for VMM is 0 – 2,147,483,647 KB. Higher the memory available for VMM, more the number of cached cubes for faster retrieval. The actual upper limit of VMM is determined by the amount of RAM available on your system.
The VMM parameter estimation could be done using Memory Used for View parameter value(in KB) available in }StatsbyCube for each cube. In order view this value make sure you start performance monitor by right clicking on server OR configure PerformanceMonitorOn=T parameter in TM1s.cfg file. Since this parameter is static, services needs restart.
2. VMT (View Minimum Time):
For each cube, this property defines the time threshold, in seconds, beyond which the algorithm that stores PLANNING ANALYTICS stargate views is triggered. PLANNING ANALYTICS will attempt to store the stargate view if the time required to calculate a cube view surpasses the specified VMT value.
If no VMT is specified the default value is 5 seconds. This parameter could be modified for each cube using }CubeProprties cube available in control objects. The valid range is 1 – 259,200 seconds.
IV. When will the Stargate Views be created?
When both criteria, VMT and VMM are met PLANNING ANALYTICS will store the stargate view. So when VMM specified is greater that memory required to calculate view and time taken to calculate view is more than VMT specified then the view will be cached. If the there is not enough memory available to store stargate view, PLANNING ANALYTICS removes oldest stargate view and stores the latest view.
Although this approach is not recommended, if you set VMT as 0 and enough VMM is available then each view will be cached. On the other hand, specifying a high VMT might not cache even a single view.
V. How long do stargate view persists?
- Consider a scenario where VMM is set as 1000 KBs. So when first request for stargate view comes for a view with 500 KB memory, this view will be stored in cache.
Next time a request comes for another view with 400 KB memory again that view will be stored. When another request comes for the third view with 500 KB memory in this case the first view will be removed from cache and third view will be stored.
- Stargate views will be removed when data is updated in the cube or cube it is dependent on.
- Stargate views will be removed when server is restarted or shutdown.
- Stargate views will be removed when cube or cube it is dependent on is unloaded.
- Stargate views will be removed when rule is updated in the cube or dependant cube.
- Stargate views will be removed when dimensions are updated in the cube or dependant cube.
VI. Leveraging the ViewConstruct function:
As we understood that the view once created will remain in the cache until it is invalidated. So overhead will be for first user who accesses the view. Only if we had a mechanism to create and keep that view in cache.
Yes, this could indeed be achieved using TI function called ‘ViewConstruct’. You can take advantage of the ViewConstruct function to prepopulate cached views. For example if you load data in a cube on scheduled basis we can use this function to create and load view using this function assuming that both VMM and VMT conditions are met.
For multiple cubes which are updated on scheduled basis, we can have a chore to execute these processes and pre populate these views in memory.
So in a nutshell Stargate views is a great functionality if used correctly with ViewContruct feature.
34 thoughts on “LEVERAGING STARGATE VIEWS”
I know this website gives quality based articles and other data, is there any
other web page which presents these information in quality?
Appreciate the recommendation. Let me try it out.
Here is my web blog … king855apk android
I am sure this paragraph has touched all the internet viewers, its
really really pleasant paragraph on building up new website.
my web blog; ok388 jackpot (918kiss-m.Com)
An impressive share! I have just forwarded this onto a friend who was conducting
a little homework on this. And he in fact bought me dinner
because I stumbled upon it for him… lol. So let me reword this….
Thanks for the meal!! But yeah, thanx for spending some time to discuss this
subject here on your internet site.
my page … test id mega888
Thank you, I’ve recently been searching for information about this topic for a while and
yours is the best I have came upon so far. But, what in regards to the conclusion? Are
you positive concerning the supply?
Review my page club suncity test id
Great article! We are linking to this great post on our site.
Keep up the good writing.
Here is my site: cara main game xe88
It’s actually a cool and useful piece of info.
I am happy that you just shared this useful
information with us. Please keep us up to date like this.
Thanks for sharing.
Also visit my homepage – ace333 id test
This paragraph is truly a nice one it helps new net users, who are wishing for
blogging.
Also visit my blog: love138 Android
What’s up i am kavin, its my first occasion to commenting anywhere, when i read this piece of writing i thought i could also create
comment due to this brilliant piece of writing.
Also visit my webpage: wukong333 kiosk
Thanks for sharing such a pleasant thinking, piece of writing
is pleasant, thats why i have read it fully
Also visit my blog … wm casino game
Hello, I do think your blog might be having browser
compatibility issues. Whenever I look at your website in Safari, it looks fine but when opening in I.E., it has some overlapping
issues. I simply wanted to give you a quick
heads up! Other than that, wonderful blog!
my website 3win8 slot game
Hello! I could have sworn I’ve been to this site before but after
browsing through some of the post I realized it’s new to me.
Anyhow, I’m definitely delighted I found it and I’ll be book-marking and checking back frequently!
my blog www2u.biglobe.ne.jp
I absolutely love your blog and find the majority
of your post’s to be exactly what I’m looking for. Would you offer guest writers to write content to suit your needs?
I wouldn’t mind writing a post or elaborating on many of
the subjects you write with regards to here.
Again, awesome weblog!
Feel free to surf to my blog post: lionking888
I think this is one of the most significant info for me.
And i am glad reading your article. But want to
remark on few general things, The web site style is great,
the articles is really great : D. Good job, cheers
Feel free to visit my blog: download pussy888 apk ios
You need to take part in a contest for one of
the finest sites on the net. I’m going to highly recommend this web site!
Take a look at my webpage; wm casinoapk android
Hello, yeah this article is truly good and I have learned lot of things from it on the topic
of blogging. thanks.
Here is my web site :: download slot game 3win8
(Herman)
Marvelous, what a website it is! This webpage presents useful facts to us, keep it up.
My homepage … list game xe88 (Jamila)
Hey there would you mind letting me know which hosting company
you’re utilizing? I’ve loaded your blog in 3 completely different web browsers and I must say this blog loads a lot
faster then most. Can you suggest a good web hosting provider at a reasonable price?
Cheers, I appreciate it!
Also visit my page … rollex11apk
I believe this is among the most vital info for me. And i’m happy reading your
article. However should statement on some common issues, The website taste is perfect,
the articles is truly great : D. Just right task, cheers
Feel free to surf to my blog; id test untuk playboy2
I think what you said was actually very reasonable. But, what
about this? suppose you added a little content? I mean, I don’t wish to tell you how to run your website,
but what if you added something to possibly grab a person’s attention? I mean LEVERAGING STARGATE VIEWS –
Blog is a little vanilla. You might peek at Yahoo’s
home page and see how they write post titles to
grab viewers to open the links. You might add a video or a pic or
two to grab people interested about everything’ve got to say.
In my opinion, it would bring your posts a little bit more interesting.
my blog – gema aaa1188
Thanks for finally writing about > LEVERAGING STARGATE VIEWS – Blog < Liked it!
my web site … free
download game sky777
Excellent post! We will be linking to this particularly great post
on our site. Keep up the great writing.
Feel free to surf to my site: lpe88 android download – xe88-my.com,
This is my first time visit at here and i am genuinely pleassant
to read everthing at alone place.
Also visit my blog – ace333 online
Link exchange is nothing else but it is just placing the other person’s weblog link on your
page at suitable place and other person will also do same in favor of you.
My web page – love138 test id; Gale,
It is perfect time to make some plans for the future and it is time to be
happy. I have read this post and if I could I want to suggest you some interesting
things or advice. Perhaps you can write next articles referring to this article.
I desire to read even more things about it!
Feel free to visit my site :: download game club suncity
It’s actually a great and useful piece of information. I am happy that you
shared this useful info with us. Please stay us up to date like this.
Thanks for sharing.
My brother recommended I might like this website.
He was entirely right. This post truly made my day.
You cann’t imagine just how much time I had spent for this information! Thanks!
Great, thanks for sharing this blog article. Much obliged.