Jun 27, 2008
Speeding up Contributor publish
2 excellent Proven Practices documents were published today, describing how to speed up publising (cognos.com login is required):
– using oracle
– using ms sql server
Same old “If you are loading data, drop indexes” roams ;)
May 30, 2008
Closed cube lattice drawer
I’ve made this simple web-based closed cube drawing tool to explain what closed cubes are and how they’re good in removing redundant aggregates from storage. I’ve wrote this for myself initially to get better insights on different aggregate situations and thought somebody might get interested as well.
May 16, 2008
Enterprise PLanning Objects Naming Convention.
As I’ve promised, here are naming conventions I tend to follow in EP projects.
Setting up naming rules doesn’t seem so crucial at project start, but generally hits on you on the head on final phase, when development turns to support.
Apr 29, 2008
Contributor transactional logic example
Finally, we’ve solved problem stated in communities. And Robert allowed me to publish resulting library here as well. See attached zip file.
Problem statement We have 2 cubes, one containing product groups sales (for example) and the other containing detailed product data.
Apr 17, 2008
Modeling transactions in Contributor
There are some situations when you definitely need some way of recognizing new input from user. These are rather rare occasions, but when it’s nice to have such a tool is sack.
Apr 1, 2008
Using Oracle Model clause in real-life )
I’ve been a long-term fan of oracle model by clause, talking about here and there, doing some small&funny examples (like eight queens solution in one select) but lacked some real-life necessity to use it.
Mar 13, 2008
DMR’s pros and cons
DMR stands for Dimensionally Modelled Relational, a Cognos modelling technique allowing to present relational data sources as OLAP cubes (this meaning adding notion of dimensions with hierarchies and measures with various aggregation rules).
Feb 29, 2008
Creating a Transformer task-balancing cluster, using Cognos 8 balancer
One more DIY article. This time we’ll talk about:
You have more than a dozen Power Cubes (20?50?100?)? And since you can use only 2 CPUs per cube on Windows platform and “update-windows” are only narrowing, you have a couple servers (3?
Feb 29, 2008
Debuging Drill-Through
Scrapped it out from my answer on cognos communities, maybe it’ll help someone.
Drill-through is really to tough to debug.
Prior to 8.3 I’ve used following routine:
Set the target report filter to optional Add 2 new text item to target report, and change them to ReportExpressions of ParamDisplayValue (?
Feb 21, 2008
Cyclic calculations in Analyst or “Make yourself an own @SliceUpdate”
In the old times, before SliceUpdate first appeared ) we’ve thought that one thing analyst lacked to be really all-in-one tool was ability to do loops. For, while, until — all that nice stuff.