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

BPC MS - Custom copy Package

Hi guru,

I need to copy a selection of data but with a custom package because I need to fix a parameter:

E.g.:

Source:

CATEGORY TIME DATASOURCE value

B 2011.10 DS_P 100

Target:

CATEGORY TIME DATASOURCE value

B 2011.11 DS_P 100

The fixed parameter will be the datasource DS_P.

My question is:

is it possible to set default parameter DS_P in package in order to avoid user to copy only this datasource? in this case, how can I forbid the user to change this fixed parameter?

thanks in advance.

Marco

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 13, 2011 at 12:16 PM

    Hi,

    If you are using a custom package, then prompt for the other dimension, but datasrc.

    In the script logic, you can scope the script to

    XDIM_MEMBERSET DATASRC = DS_P

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 10, 2011 at 08:51 AM

    Hello Marco,

    you can use the standard copy package and click on the save button when you choose the parameters that you want fix.

    When you execute the copy you load before the saved parameters and after you add the others.

    Best regards

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Marco,

      you can write in the package something like

      DEBUG(ON)

      PROMPT(TEXT,%Year%,"Select the destination year as: AAAA",,"")

      PROMPT(TEXT,%Month%,"Select the destination month as: JAN,FEB,MAR...",,"")

      PROMPT(TEXT,%CATD%,"Select the destination Category:",,"")

      INFO(%DATASRC%,DS_P)

      in this exemple year, month and destination category are variables and datasource is fixed (DS_P).

      Hope this helps

      Best regards

      Roberto

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2011 at 12:05 PM

    Hy Marco,

    i have the same problem.

    How have you resolved?

    Best regards,

    Simone

    Add a comment
    10|10000 characters needed characters exceeded

    • BEGININFO(%SQLDUMP%)

      select %FACTDIMS%,SUM(SIGNEDDATA) AS SIGNEDDATA FROM (SELECT %FACTDIMS%,sum(SIGNEDDATA) as SIGNEDDATA FROM (SELECT %FACTDIMS%, SIGNEDDATA FROM TBLFACT%APP% WHERE %SELECTION% AND DATATYPE IN ('DT_PERC','DT_DRIVER')

      UNION ALL SELECT %FACTDIMS%,SIGNEDDATA FROM TBLFACTWB%APP% WHERE %SELECTION% AND DATATYPE IN ('DT_PERC','DT_DRIVER')

      UNION ALL SELECT %FACTDIMS%,SIGNEDDATA FROM TBLFAC2%APP% WHERE %SELECTION% AND DATATYPE IN ('DT_PERC','DT_DRIVER')

      ) AS SourceTable GROUP BY %FACTDIMS% union all SELECT %FACTDIMS%,0 as SIGNEDDATA FROM (SELECT %FACTDIMS%,0 AS SIGNEDDATA FROM TBLFACT%APP% WHERE %TOSELECTION% AND DATATYPE IN ('DT_PERC','DT_DRIVER')

      UNION ALL SELECT %FACTDIMS%,0 AS SIGNEDDATA FROM TBLFACTWB%APP% WHERE %TOSELECTION% AND DATATYPE IN ('DT_PERC','DT_DRIVER')

      UNION ALL SELECT %FACTDIMS%,0 AS SIGNEDDATA FROM TBLFAC2%APP% WHERE %TOSELECTION% AND DATATYPE IN ('DT_PERC','DT_DRIVER')

      ) AS zeroTable GROUP BY %FACTDIMS%) as TotalTable group by %FACTDIMS% OPTION(MAXDOP 1)

      ENDINFO

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.