Hello there,
Here is a nice link where you can find all wildcards that can be used in the VLDB properties:
Hope it helps.
God bless you.
Hello there,
Here is a nice link where you can find all wildcards that can be used in the VLDB properties:
Hope it helps.
God bless you.
Hello there!
There is a excellent vldb option to execute in parallel independent sql passes.So. if you have more than one pass in your SQL and those aren’t dependent, you can instruct Microstrategy to execute them separately. Microstrategy will open DB connections to execute those SQLs.
Example:
You have a query with some passes like:
Pass1
Pass2
Pass3
Pass4
If Pass1 isn’t dependent of Pass2, Microstrategy will execute them separately.
To do that, you just have to:
1. Open your report;
2. Click on Data -> VLDB Properties
3. Select Query Optimization -> Parallel Query Execution
Justchoose one of those 2 “Enable” options. Just read it and see which one is better for you.
Hope it helps!
God bless you!