Skip to Content
author's profile photo Former Member
0
Former Member

Passing parameters through drill through

Posted on Apr 19, 2011 at 09:33 PM 7 Views

I'm trying to setup drill through for the journal entries. Can you please let me know how to pass parameters to the query like all the dimensions values from the current view.

Any info is appreciated.

Regards,

Suresh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 20, 2011 at 03:13 PM
    0

    Hey Suresh -

    We've been using the drill-through functionality for about a year and it works fairly well for us. We're using the drill through to execute a Stored Procedure and return data from our Financials system. Here's an example of how we pass the parameters:

    exec STORED_PROCEDURE_NAME '%TIME', '%BUSINESSUNIT%', '%ACCOUNT%', '%COSTCENTER%', '%MEASURES%'

    Hopefully this helps you out.

    Good luck!

    Sean

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Apr 20, 2011 at 03:46 PM

      Thanks for the reply. We have stored procedure and there are pparameters passed to that. I have reports that works for drill through and when I'm trying to drill through the same account in Journal I do not see the option for drill through. I have the DRILLKEY property setup for the account.

      Can you please let me know how I can drill thorough the Journals.

      Regards,

      S

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.