Sitemap

Amicuk Programming Answers

Passing Dimension Members to Logic Task in SSIS

-0001-11-30   Views:1

Advertisement

I have a package that pulls data from a source and loads it into BPC. As a part of the package, if data is loaded into prior periods (I identify this through a query and put the prior periods and accounts into variables), we then need to run a piece

I have a package that pulls data from a source and loads it into BPC. As a part of the package, if data is loaded into prior periods (I identify this through a query and put the prior periods and accounts into variables), we then need to run a piece of script logic that rolls forward the necessary balances based on the time periods and the accounts included. Right now, the package generates an email and includes an expression noting the prior time periods and accounts, and and then the users go and manually run the logic for the time periods and accounts specified in that notification email. However, we want to automate that step at the end of the package. What is the best way to pass the time period and account variables into script logic to limit the scope to just those accounts and the time periods specified?

The replay answer
Advertisement
Thanks Roberto. That certainly is an option. I can't define the appropriate accounts and time periods through any BPC tables, so I believe that I would need set a Property, something like "RunLogic", in the mbrTime and mbrAccount tables using a query in an Execute SQL task first, and then in the script logic use the Select statements to set a variable like you mentioned, and then use that variable to define the scope in the XDIM_MEMEBERSET statements.
But, is this the best, cleanest way to do this? Given that the Logic task was built for SSIS, it seems to me that there would be a direct way to simply define the scope in the task using an expression and/or variables, or through ModifyScript. Is there a way to simply pass the variables through and leverage a dynamic constant or something else that is already built into BPC?

Go to See the other 3 answers

Passing Dimension Members to Logic Task in SSIS

Category:DefaultRelease time:-0001-11-30Views:130

I have a package that pulls data from a source and loads it into BPC. As a part of the package, if data is loaded into prior periods (I identify this through a query and put the prior periods and accounts into variables), we then need to run a piece[More]

How to auto-update of script logics after adding new dimension members?

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, Just wanna ask if BPC has a functionality that would automatically update/validate and save my script logic whenever I add new dimension members. I've added new PL accounts but they are not automatically added to my calculated BS Net Inco[More]

Maintain dimension members directly into the data base

Category:DefaultRelease time:-0001-11-30Views:130

Hi, We need to update the dimension members directly into the data base. Instead of going into the administration and entering manually. I tried just updating the table mbr and dim. but that didn't work. Any insight on that?To update the dimension me[More]

Cannot maintain dimension members in SAP BPC

Category:DefaultRelease time:2015-10-11Views:130

Hello, Masters in BPC I have just create mention and want to input data, I used maintain dimension members CUSTOMER in SAP BPC but It seem not effect although I press Process dimension already and I open excel and paste data also saved them already.[More]

Concatenate text and property of dimension in script logic

Category:DefaultRelease time:2015-10-11Views:130

hello experts, how to concatenate text and property of dimension in script logic? as example: dimension : interco property    : mgmtallocdefcc *WHEN TIME.YEAR *IS %YEAR_VAR% *REC(EXPRESSION=%VALUE%,ACCOUNT=12345,ENTITY="I_" [INTERCO],MGMTALLOCDE[More]

Import Comments data and Dimension Members from csv file via Data Manager

Category:DefaultRelease time:2015-10-11Views:130

Dear Experts, I have two questions regarding the data manager. Q1.Is it possible to import "Comments" from the csv file via Data Manager? We'd like to import the amount with "Comments". My image of csv file is like below; ACCOUNT,CATEG[More]

[ASK] Get One Row of Property Value From Dimension in Script Logic

Category:DefaultRelease time:-0001-11-30Views:130

Hello, i need help about how to get one row of property value from dimension in script logic. Let say there is CATEGORY dimension and the members are like this : ID                                                  YEAR   Status PLAN_2011             [More]

XML Task in SSIS 2012

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I need help on one requirement in SSIS 2012, Please let me know for any suggestions or solution. I have two XML files having different structure, I have to manipulate data by applying XSLT and creating single output xml. (Which needs to pass[More]

Activating audit for Dimension Members in BPC 7.5 NW

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Is it possible to activate dimension member audit in BPC 7.5 NW. Meaning, can we trace changes to master data (dimension members) in BPC 7.5 NW? Best regard SSCHi, The Activity Auditing tracks Administrative and User tasks at the Appset level. Th[More]

Dimension Members in BPC is not updating

Category:DefaultRelease time:-0001-11-30Views:130

Dear Friends, I have trasfered the values of the 0GL_ACCOUNt to the account dim of my appset in BW using the transformation and i could see the values in the BPC display dimension members. But simillary i have created the transformation and uploaded [More]

Dimension members -Question???

Category:DefaultRelease time:-0001-11-30Views:130

Is it possible to add dimension members using script logic?Thanks for your reply. i am working on TOP down allocation..since we cannot  write data to a parent member, i want to create a dummy base  member for an entity to  store the total and then do[More]

Hot
I have 11 updates in my App Store but every time I click the update they ask first my apply ID that would be fine but after they will ask my credit card details since this is only to update. Please help me. Also, even I would like to download some ga [More]
When I have a pdf in my firefox browser and I click to save it, as soon as I click on the "UP" folder on the screen to navigate to the folder I wish to save the pdf in, an hourglass appears and firefox stops responding. I can't close firefox or [More]
Hi: There is something strange with my shuffle, the first time when I bought it apparently it was working fine on my computer, but later when I was trying to add more music, I began to have problems. First, there was an orange flashing light on it an [More]
Hi,   I  am getting Dump error while i am trying to create Sales order for Perticular Company Code not for other company code theire there is no Dump. Runtime Errors         SAPSQL_INVALID_FIELDNAME Except.                CX_SY_DYNAMIC_OSQL_SEMANTICS [More]
I would like to connect my old iMac 20inch to an external monitor. This external monitor(probably 24 to 27inch)  will play as primary monitor. What is the maximum resolution on external monitor if I mirroring my imac? My old iMac curent resolution is [More]
Hi SDN Gurus, I want to display employee photo in my custom webdynpro abap application. Im using Document Area as blank, Storage type as SAP System Database and Rep. Sub-Type as Normal and Content Table is SDOKCONT1 in tcode OAC0. I have written a FM [More]
Using information helpfully provided by Kappy and The Hatter on this forum (see topic https://discussions.apple.com/message/27751034?ac_cid=op123456 if interested) I found that I was able to get my Mac Pro (early 2008) 3,1 to boot in 64 bit mode, and [More]
I wanted to transfer some apps to my SD card and I was only able to transfer about 10 and the rest wouldn't. The 'transfer to SD card' button wasn't highlighted and when I tried it, it wouldn't actuate. Is that normal? I've had a couple of Droid's wi [More]
Everytime i try to open any new page on safari, this message pops up stating slow script error>>>>>with option to stop or continue!!Hi, Only with a later version of OSX that allows a later version of JavaScript.Read other 2 answers [More]
Hello, I am new to this organization and taking over an existing RoboHelp 8 HTML online FlashHelp project. My supervisor has requested that I find out how to get our RH8 HTML project into a RH8 Word project, and after reading this forum and others, t [More]