Showing posts with label business intelligence. Show all posts
Showing posts with label business intelligence. Show all posts

Wednesday, November 11, 2009

Init Blocks

What are INIT BLOCKs?

They are pieces of code that you write in the Admin tool to initialize repository and session variables.

For example you might have a variable that gives you the current date or another that says how many days there are left until the end of the quarter. You write init blocks to initialize these variables with the correct values.

Initializing Repository Variables

Init blocks that initialize repository variables are only run at a scheduled time. When you create one of these you set the time and scheduler to run. If the BI Server is restarted they also get run.

Initializing Session Variables

Init blocks that initialize session variables are not run at a scheduled time. Instead, every time a user begins a new session these variables are initialized and they remain unchanged for the length of the session.

Thursday, August 13, 2009

Rename Column In Presentation Layer

If you rename a column in the Presentation layer then all of your reports that use the column are now going to be referencing the wrong column and thus will error.

To fix this:

Search and replace using the catalog manager
Search for Presentation Table.Market and
Replace with Presentation Table.Markets.