Skip to Content

Distribute BPC reports when offline?

I'd like to schedule reports to be distributed during period close activities automatically. I've run across a few problems while doing this. We are on BPC 10.1 NW

1. My scheduling requirement is beyond what is available so I need to create two separate schedules, but this is not possible because each time I create a new scheduled task to distribute the reports it overwrites the previous task. I read in some documentation that we are unable to change the windows task name...as such can only have one scheduled task for BPC report distribution. Any work around?

2. I'd like to schedule the reports to run at times that I may not be at work and my computer may be offline. If my computer is offline and not connected to the network then the windows task will not execute. Any work around on this? Schedule on app server directly?

3. Ideally I could add this distribution schedule as the last step of my package link to load all data to BW->BPC. I've not seen that this is possible. Perhaps with a custom developed package? Is anyone else doing this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 24, 2017 at 05:31 PM

    Better solution:

    EPM distribution will create windows task schedule with the following command to execute:

    C:\Program Files (x86)\SAP BusinessObjects\EPM Add-In\FPMXLClient.BooksPublication.exe

    "C:\Users\KalininVE\Documents\PC_NW\KalininVE\Books\ENVIRON_NAME\MODEL_NAME\WebExcel\BatchFiles\D 10.0.60.33_8000 ENVIRON_NAME MODEL_NAME KalininVE"

    where "D 10.0.60.33_8000 ENVIRON_NAME MODEL_NAME KalininVE" is xml file like:

    <?xml version="1.0"?>
    <BookStructureList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <List>
    <BookStructure>
    <PathBookTemplate>C:\Users\KalininVE\Documents\PC_NW\KalininVE\Books\ENVIRON_NAME\MODEL_NAME\ADMIN\WebExcel\ManageDistributionList\TestD.xltx</PathBookTemplate>
    <PersistConnectionName>_FPM_BPCNW10_[http://10.0.60.33:8000/sap/bpc/]_[ENVIRON_NAME]_[MODEL_NAME]_[false]_[false]</PersistConnectionName>
    <ApplicationName>MODEL_NAME</ApplicationName>
    <ClearBook>Accumulate</ClearBook>
    <TemplateType>DistributionList</TemplateType>
    <VariableTime />
    <Name>TestD</Name>
    <SectionStructureList>
    <SectionStructure>
    <Name>Main</Name>
    <SectionEnabled>true</SectionEnabled>
    <ClearSection>Accumulate</ClearSection>
    <ReportStructureList>
    <List>
    <ReportStructureItem>
    <Description>ttttttt</Description>
    <ReportPath>%REPORTS%\%ADMIN%\REPORTS\TestReport1.xlsx</ReportPath>
    <SubFolder>REPORTS</SubFolder>
    <Workbook>TestReport1.xlsx</Workbook>
    </ReportStructureItem>
    </List>
    </ReportStructureList>
    <FixMemberList />
    <SuppressCriteria />
    <VarMembers>
    <VariableElementsStructure>
    <MemberStructureList>
    <MemberStructure>
    <Dimension>COMPANY_CODE</Dimension>
    <Member>[COMPANY_CODE].[PARENTH1].[CO_XX00]</Member>
    </MemberStructure>
    <MemberStructure>
    <Dimension>USER ID</Dimension>
    <Member>KALININVE</Member>
    </MemberStructure>
    </MemberStructureList>
    </VariableElementsStructure>
    </VarMembers>
    </SectionStructure>
    </SectionStructureList>
    <FinalAction>Print</FinalAction>
    <FileName>TestD.xltx</FileName>
    <StorageTeam>
    <Id>ADMIN</Id>
    <Description>ADMIN</Description>
    <IsTeamLeader>true</IsTeamLeader>
    </StorageTeam>
    </BookStructure>
    </List>
    <FilePath>C:\Users\KalininVE\Documents\PC_NW\KalininVE\Books\ENVIRON_NAME\MODEL_NAME\WebExcel\ManageDistributionList\</FilePath>
    <Type>DistributionList</Type>
    <PersistConnectionName>_FPM_BPCNW10_[http://10.0.60.33:8000/sap/bpc/]_[ENVIRON_NAME]_[MODEL_NAME]_[false]_[false]</PersistConnectionName>
    <ApplicationName>MODEL_NAME</ApplicationName>
    <FinalAction>XlsSave</FinalAction>
    <IsLocal>true</IsLocal>
    <DestinationPath>C:\Pictures</DestinationPath>
    <SinglePdfConfiguration>
    <PublicationDestination>PrivatePublication</PublicationDestination>
    <Enabled>false</Enabled>
    </SinglePdfConfiguration>
    <SingleWorkbookConfiguration>
    <Enabled>false</Enabled>
    </SingleWorkbookConfiguration>
    <MailConfiguration>
    <RequestConfirmation>false</RequestConfirmation>
    <ZipAttachments>false</ZipAttachments>
    <InboxCopy>false</InboxCopy>
    </MailConfiguration>
    <SMPTConfiguration>
    <Address /><UserId /><Password />
    <AuthenticationType>0</AuthenticationType>
    <Port>0</Port>
    <EnableSsl>false</EnableSsl>
    </SMPTConfiguration>
    <SheetBySheet>false</SheetBySheet>
    <PrintEmpty>true</PrintEmpty>
    <CredentialsForSerialization>
    <BPCCredentials>
    <UserLogin>xxxxxxxxxxxxxxxxxxxxxx</UserLogin>
    <UserPassword>xxxxxxxxxxxxxxxxxxxxxx</UserPassword>
    <ShouldCheckCredentialsBeforeConnect>false</ShouldCheckCredentialsBeforeConnect>
    <CredentialsType>Basic</CredentialsType>
    </BPCCredentials>
    </CredentialsForSerialization>
    </BookStructureList>

    Containing all information for distribution!

    You can schedule the same yourself using Windows task scheduler multiple times using different task names and different times to execute!

    Use Manage Computer -> Task Scheduler...

    Add comment
    10|10000 characters needed characters exceeded

  • May 24, 2017 at 03:58 PM

    1. Please explain you requirements step by step! Not clear why do you want to schedule the same thing twice...

    2. Use dedicated PC somewhere on your corporate network always switched on with Excel and EPM installed. Use RDP to connect to this PC and launch distribution from this PC. "Schedule on app server directly?" - not possible!

    3. Not possible.

    Add comment
    10|10000 characters needed characters exceeded