Web Intelligence Tech Tip

Question: In XI R2, when I refresh Web Intelligence or Desktop Intelligence documents, that contain prompts with Lists of Values, I experience, long, sometimes unacceptable wait times until the prompts are displayed. What is the cause for this? Answer: The cause for this problem is the fact that the Lists …

The Ranking button, for filtering a dimension based on its corresponding measures, will return the top or bottom ranked results. Consider the 15th ranked result. What if there were 16 values at the bottom that are evenly ranked? In this case, requesting the top 15 results returns 30 values, 16 …

Alerters are available in v6.5, however, if using the earlier version, you might find the following techtip useful. Alerters are used in the full client tool to apply conditional formatting. Although Alerters are not available in WebIntelligence as a toolbar button and interface, like they are in the full client, …

If you save a sectioned report as HTML and choose the “section by section” option, the sections are saved in separate HTML pages numbered from 0 (i.e. 0.htm, 1.htm, etc.). In wanting to link to these sectioned pages from another sectioned page, you need a way to correspond the link …

QUESTION: How do I format a Month Number to a Month Name? ANSWER: Most of our date conversions come directly from a date. If given just the month number, however, you must first convert the number into a valid date format and then you may use the FormatDate() function to …