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!

Recent content by Stevennn

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

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

    Drill-through???

    Cognos 8.3!
  4. Stevennn

    Drill-through???

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

    ReportStudio, Cube, Prompt?

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

    ReportStudio, Cube, Prompt?

    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!
  8. 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
  9. Stevennn

    Filters?

    got it to work, thank-you Bloom!
  10. Stevennn

    Filters?

    :), 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 ?
  11. Stevennn

    Filters?

    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 '-%'...
  12. 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!
  13. 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!
  14. Stevennn

    Metric Studio to Report Net Cognos8

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

    Metric Studio to Report Net Cognos8

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

Part and Inventory Search

Back
Top