Topic
  • 7 replies
  • Latest Post - ‏2013-03-20T18:03:19Z by DanielWagemann
pennahb
pennahb
20 Posts

Pinned topic How to write back the data to show in Reports

‏2013-02-26T17:58:54Z |
Hi,

We have a requirement in cognos reports , the user want reports should be flexible to enter data , and the data should store in the data base to again show the totals based on that values entered.

For example : First time when we run the report ,result has to come for the object 'A' totals . The user will enter AA,AB from report to database and again the report should show the result including Object A, AA,AB Totals.

Let me know any of you got a chance to work on this type of scenario, and the process steps to do it.

Thanks in Advance.........
Updated on 2013-03-20T18:03:19Z at 2013-03-20T18:03:19Z by DanielWagemann
  • vigneswar
    vigneswar
    10 Posts

    Re: How to write back the data to show in Reports

    ‏2013-02-27T16:29:43Z  
    You can try using store procedure query subjects to write back to database.
  • DanielWagemann
    DanielWagemann
    411 Posts

    Re: How to write back the data to show in Reports

    ‏2013-02-27T16:32:16Z  
    • vigneswar
    • ‏2013-02-27T16:29:43Z
    You can try using store procedure query subjects to write back to database.
    Yes you can import a data modifcation stored procedure within FM and expose it to the reporting level. From there you could hook type in prompt values as inputs into the stored procedure. As the procedure executes it would insert values into a table. Assuming the cache is disabled, the next time a report that draws data from the table should have the new values.
  • pennahb
    pennahb
    20 Posts

    Re: How to write back the data to show in Reports

    ‏2013-02-27T19:13:01Z  
    • vigneswar
    • ‏2013-02-27T16:29:43Z
    You can try using store procedure query subjects to write back to database.
    Thanks Vigneswar.
  • pennahb
    pennahb
    20 Posts

    Re: How to write back the data to show in Reports

    ‏2013-02-27T19:15:42Z  
    Yes you can import a data modifcation stored procedure within FM and expose it to the reporting level. From there you could hook type in prompt values as inputs into the stored procedure. As the procedure executes it would insert values into a table. Assuming the cache is disabled, the next time a report that draws data from the table should have the new values.
    Thank you very much Daniel.
  • pennahb
    pennahb
    20 Posts

    Re: How to write back the data to show in Reports

    ‏2013-03-19T18:22:31Z  
    Yes you can import a data modifcation stored procedure within FM and expose it to the reporting level. From there you could hook type in prompt values as inputs into the stored procedure. As the procedure executes it would insert values into a table. Assuming the cache is disabled, the next time a report that draws data from the table should have the new values.
    Hi Daniel,

    Now we are about to start Stored procedure approach to Write back the data,

    I have one doubt in implementing this. we already have one package ,this new stored procedure we want to add to that existing Model to Publish the package. Is it possible to add the stored procedure to the existing model without disturbing existing Relations?.

    thanks
  • pennahb
    pennahb
    20 Posts

    Re: How to write back the data to show in Reports

    ‏2013-03-19T18:23:26Z  
    Still i have some doubts on implementing stored procedures.
  • DanielWagemann
    DanielWagemann
    411 Posts

    Re: How to write back the data to show in Reports

    ‏2013-03-20T18:03:19Z  
    • pennahb
    • ‏2013-03-19T18:22:31Z
    Hi Daniel,

    Now we are about to start Stored procedure approach to Write back the data,

    I have one doubt in implementing this. we already have one package ,this new stored procedure we want to add to that existing Model to Publish the package. Is it possible to add the stored procedure to the existing model without disturbing existing Relations?.

    thanks
    It all depends on how you are going to implement it. A stored procedure will become its own query subject. If you want include it in a query that is already used in your report, then it will require some sort of relationship.

    If you plan on adding the stored procedure as its own query, maybe tied to its own Report Page, then it would not require any relationships.