1.  partition    select c1,c2,c3, rank() over(partition by c2 order by c3 desc)    as r1, rank() over (order by c3 desc) as r2    from t1    where c2 in (15,20)    order by c2,c1   ...(more)

我在管理控制台中进行如下操作：点击reporting——》点击new report——》点击datestage——》选择jobrun information for selected jobrun——》点击next进入报告设置的页面——》在report settings 下面有"select project"菜单，我当前遇到的问题是不能从中选择我指定的pr...(more)

Before you start, you must understand the reporting problem that you are trying to solve and what data is available to solve it. If you cannot address the following questions, talk to your users about their reporting requirements:     ...(more)

Download a free trial of IBM Cognos Express, the first and only integrated business intelligence (BI) and planning solution purpose-built for midsize companies. Get essential reporting, analysis, dashboard, scorecard, planning, budgeting & forecastin...(more)