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

I’m using Report studio to Report studio. Both are cube reports. When you set the drill-through I have to define what I will be passing from the report. I have two options parameter value which I don’t have for this report so I have to pass data item value. But I have different tree levels in...

Cognos 8.3!

If anyone has any idea, can you please let me know! 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...

Thank-you for your input! I used set(lag(.... for cube. I’m trying to do almost the same for a relational model report. But I’m experiencing problems. EX: If the user selects March, 2007, the report should show March, 2007 and the Prior Month = February,2007 and YTD. If the user selects May...

Running-total time? Why? The user needs to have an option to see the report for any months he desires, when the user chooses the period the report needs to display also 12 more months prior to the period selected! Please let me know if you can Help!

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

got it to work, thank-you Bloom!

:), wow, i dont know what i was thinking! that was pretty stupid of me. Yeah im dealing with numeric! i should still use the case statment? So i will create two data item in the query: CASE WHEN [AP].[AMOUNT] < '0' THEN [AP].[AMOUNT] ELSE > '0' END ?

Hi Bloom, Thank-you for helping! I have an amount field, and i want to break it down into credits and debits. I looked at the data source, this is what i see: AMT -183743.34 834754.23 -343545.67 435454.99 Does this make a difference? That is why i thought of pulling it by contains '-%'...

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 Ties, Say if i create a package in FM with the formulas i need and posted to the C8 server than i can use that package in report Studio. What about if i create package (scorecards) in Metric Studio using simple formulas to track goals (KPIs) and some users want to see those KPIs is...

Is this a very hard question that no one knows the answear to?

anyone? thanks

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

Mafusa, Thankyou for taking your time to help me out with my problem! I think i fixed it, I wont know untill I will validate the data..... Again thank-you so much!!!