Search results for query: *

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

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

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

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!

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!

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!

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

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

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

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

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

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

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

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

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

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

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

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

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

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