Search results for query: *

Hi, Can we see columns set as _memeberDescription anywhere in Analysis Studio. What other ways do we have to display the metadata in Cognos Connection Studios? The options I can think of are: - tool tip It is limited to the x characters and must be put in manualy? I can not e.g. import...

You can create the calculation in query subject which namely says: - count(distinct sales.Customer_id) then set this calculation as fact. It should group by automatically...

Hi, I've come recently against some little problem I am unable to implement in ReportNet. Here is the simplified description: Assume we have ORDER table in our db with the following fields: - Order_number - Customer_number - Product_name - Product_type - Date We would like to obtain...

Thanks DoubleD and Puppyquestion1, Sometimes I think that BI development is just different from ordinary application dev process, so maybe there should be just one person providing end-2-end solution. Acting at the same time as BA, solution architect and developer? Rgds, Seweryng

Hi, I have like few years of experience in delivering different Cognos solutions. I have a little non-technical question. I would be happy however to hear from your experience and your practice. Imagine the world when business users are contacted only by business analysts then BA create the...

What if we precalculate this distinct count in SQL and add this as externally rolled-up measure. This should save us space. On the other hand if you are going to have drill-down to policy no level, the cube is going to be big anyway. By the way, does anyone know whether we have the...

Hi GJParker, I,ve got similar problem with importing data from unix Informix db. You can do this with use of DTS global variables. (Right click menu, package properties, second tab). First, you can create a SQL step, using SQL server connection. This step will set the global variable. Then...

croydon, Sorry, actually after doing small test the y from solution 2 should be = min(id), Rgds, Seweryn

Hi, solution 1: You can use any of random number generators, like e.g. described in: http://random.mat.sbg.ac.at/generators/ Simple one of them can be calculated as: y(n+1) := A*y(n) + B (mod p) A,B are just any numbers y(0) can be iplemented as cast(getdate() as int) Therefore you will...

Hi edvwhi, You can insert more then one query into a single report. Therefore, - create first report as a primary query - create second report as a subquery (menu insert\subreport) as a form frame (You must initially select some values into this frame) - depending of the layout of the second...

Sniggih, If I understood you correctly, you want to change summary rollup of the measure into weighted average. Is that right? This can be done for calculated and column type measures in the measure properties, rollup tab. You choose average rollup and any other measure as the weight. Rgds, S.

Hi Sagae, Why do you use hotfiles? Are these tables come from different dbs? Rgds, S.

Hi, There is one solution... You can display the columns you want hide in a separate list frame as a subquery. Then you can hide whole frame with conditional format. Little strange but should work. Regards,