Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. seweryng

    _memberDescription in Analysis Studio (+ more general metadata issue)

    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...
  2. seweryng

    Calculated measure

    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...
  3. seweryng

    not additive measure in ReportNet

    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...
  4. seweryng

    BI business requirements document

    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
  5. seweryng

    BI business requirements document

    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...
  6. seweryng

    Distinct Count in PowerPlay Transformer

    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...
  7. seweryng

    using calculated date in SQL

    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...
  8. seweryng

    Updating a table using SP

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

    Updating a table using SP

    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...
  10. seweryng

    How to add data from a second Report to the first one

    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...
  11. seweryng

    Recalc a measure

    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.
  12. seweryng

    Passing prompt through report dependencies in IWR

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

    Dynamically hide columns

    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,

Part and Inventory Search

Back
Top