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 Chriss Miller 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: *

  • Users: Stevennn
  • Content: Threads
  • Order by date
  1. Stevennn

    Analysis Studio

    Hi, I’m using Analysis Studio, In order for me to drill-through from 1st cube (summary) to a 2nd cube (detail) do I have to build a report from a 2nd cube so i can drill-through to that report or I can just drill through to the cube without building a report of the 2nd cube? Thank-you
  2. Stevennn

    Drill-through???

    Hello, Seems to me so easy but it's not working the way Im doing it! Im using an account tree in the report. 1st cube has 4 levels, 1-4. 2nd cube has 2 levels, 4-5. 1st level starts with All_Accts I created a crosstab. Pulled couple of nodes from 2nd level and couple from 3rd level...
  3. Stevennn

    ReportStudio, Cube, Prompt?

    Hi Cognos Wizards, I'm building a report in RS using a cube as a source. I created a date prompt, User can select from a drop down list: Jan-06, Feb-06 and so on.... How can I set up if the user will select Jan-07, it will show in the report last 13 months? Thank-you! Steven
  4. Stevennn

    Filters?

    Hello Guys, if u can help that would be great! working with relational model. got a column with amount: would like to split it into two columns. one contains '-%' and the 2nd not contains Set it as a filter, works only for one condition but not for both. What should I do? Thank-you!
  5. Stevennn

    2 packages for the same report

    Hello guys, please help! 1.Is it possible to build one report out of the 2 different packages? 2. or build a report out of a cube and a package? 3. why would you build a cube and post for to cognos connect instead of building a package in a FM, can the cube work better? thank-you for your input!
  6. Stevennn

    Metric Studio to Report Net Cognos8

    Hello Guys, If you create KPI's formulas in Metric Studio (without using Metric Designer) can you use the same formulas that you wrote in Metric Studio, use them in Report Studio without re-writing them? If yes, would this effect performance, and how would you do this? Thank-you!
  7. Stevennn

    Setup Question

    Hi, I know this might be a shot in a dark but i thought maybe one of you can guide me in a right direction...... Just installed SQL Server 2005 (on my laptop) on XP PRO SP2,,, 1. Wanted to start testing it out...downloaded some sample data bases, Opened Microsoft visual Studio ,,,opened a...
  8. Stevennn

    Sequence.....

    Im doing a data transfer in Cognos Decisoin Stream...... I did not set up any measures or dimensions because all Im using it for is to do a DATA TRANSFER....... I ran intoa problem of setting up a SEQUENCE.... How can i set up a sequence as a Deriviation in (DataStream or Transformation Model...
  9. Stevennn

    ORA-22818 subquery expression not allowed here

    It's not reading CASE in GROUP BY! Can anyone explain what is wrong? This script works only if I delet SUM and GROUP BY or if i delet CASE statment from GROUP BY than it works too (but than it freezes after 100 records, i think because it hits SO transactions) Thank-you!!!! SELECT b.en_ent...
  10. Stevennn

    Help with a Join !!!!!

    Hello, Here I'm doing two JOIN queries. I need help with inserting 2nd query into 1st. in the final result I would like to see all the transaction that are 'PP' w customer_name and the rest of the transactions that are not 'PP' i would like to see them as 'N/A' for customer_name Thank-you...
  11. Stevennn

    WriteFile error

    Everything was runnig fine for two months,,,now i got this error and i dont know what it is!!!! DS-LIB-E500: Windows OS function 'WriteFile' error 232; The pipe is being closed. DS-FILE-E202: Error writing to data file '\\.\pipe\ORALOAD_00000f78_EA_4.dat' I uncheked Use Named Pipes but then...
  12. Stevennn

    Surrogate Key

    Hi, How can I set up surrogate key with using Fact Build. I dont have any dimension builds or lookups. Thank-you very much!!!!
  13. Stevennn

    to_number

    Im doing Select statment with CASE but i got a problem i need to convert gl_acc and gl_cc to NUMBER right now they are varchar2. So the BETWEEN should be read as number not as charctor for that range!!! And pull only those records where MEASURE not equals to NULL.... Thank-you for your...
  14. Stevennn

    NULL? please help asap

    I'm trying to pull data thru progress and I need to execute this statment but it's not working.. IFNULL(TO_CHAR(commission_pct), 'NONE'), i tried it with ISNULL also..... Any ideas what script to use to put in 'NONE' into NULL fields............... Can't do update because it needs to be done...
  15. Stevennn

    IF THEN

    I have a field that might contain NULL How can i incert there word NONE??? IF cc_accd = NULL then 'NONE'???????
  16. Stevennn

    decode?

    I'm trying to pull a column name Month_Year the value is Jan-2005. How can i make my extract look likt this: "JAN"? thank-you
  17. Stevennn

    MAPPING

    Im mapping two tables, But i got a problem. One table has 400 records the other 120. The final result only 120 record. How can I still have those records show up which are not in the 2nd table but in the 1st (400 records). I don’t know if its relevant but I’m also using DISTINCT to pull those...
  18. Stevennn

    GROUP BY ORA-00979: not a GROUP BY expression

    I get this error when i try to run it ORA-00979: not a GROUP BY expression. I know that group by ,must include everything in SELECT. Still not working. ANy ideas? thank-you for the help SELECT e.ar_ent, a. ex_ent, e.ar_cc, c.cx_ctr, e.ar_acc, d.ax_acc...
  19. Stevennn

    SQL script!

    I'm trying to execute the script below and it wont do it. Is it possible to figure out what is wrong with it! "SQL command not properly ended" Thank-you SELECT en_code, sa_sub, costctr_code, acc_code, sum(gl_amt) FROM D_ENTITY_STG1 a...
  20. Stevennn

    SQL script

    I'm trying to execute the script below and it wont do it. Is it possible to figure out what is wrong with it! "SQL command not properly ended" Thank-you SELECT en_code, sa_sub, costctr_code, acc_code, sum(gl_amt) FROM D_ENTITY_STG1 a, D_SUBACCTS_STG1 b...

Part and Inventory Search

Back
Top