User Package Not Working Properly

[former_member595001]

Hello,

One of our users' data packages they use to load their data from their server into BPC isn't working correctly. The user can only chose one dimension, when there's usually three to chose from. I checked in the admin console, to make sure their username had the correct security which it does, but I'm out of ideas and I couldn't really find anything online to help me with this issue.

This is what the users package looks like, which is incorrect due to it only showing the "Category" dimension.

This is what the package should look like, with all three dimensions showing up.

Hopefully this is an easy fix. We're currently on BPC 10.1 SP34P2.

Thanks,

WIll

[former_member186338]

Pleas provide the text of DM advanced script for this particular DM package!

[former_member186338]

I am not an expert in BPC MS, but the line

PROMPT(SELECTINPUT,%X%,%Y%,"Select the Entity, Time and Category to load
 financials from Visual:",%ENTITY_DIM%%TIME_DIM%%CATEGORY_DIM%)

is incorrect!

Has to be:

PROMPT(SELECTINPUT,%X%,%Y%,"Select the Entity, Time and Category to load
 financials from Visual:","%ENTITY_DIM%,%TIME_DIM%,%CATEGORY_DIM%")

to prompt for ENTITY, TIME and CATEGORY

[former_member595001]

Okay, but it works fine for everyone that way, but that user. But, I can make the change. Do you know a reason why the specific user will not be getting all the prompts?

[former_member186338]

wilvit

No idea) but try proposed syntax!

[former_member595001]

Hi Vadim,

Is this what you wanted? Sorry, I'm not in IT, so I'm not 100% sure if this is the right script you're looking for.

DEBUG(ON)
PROMPT(SELECTINPUT,%X%,%Y%,"Select the Entity, Time and Category to load financials from Visual:",%ENTITY_DIM%%TIME_DIM%%CATEGORY_DIM%)
TASK(GET_ENTITY_INFO,SQLSTATEMENTSOURCE,Select * from dbo.vw_BPC_Entities where Entity = '%ENTITY_SET%')
TASK(GET_FISCAL_TIME_INFO,SQLSTATEMENTSOURCE,SELECT * from dbo.BPC_Time where Time = '%TIME_SET%')
TASK(GET_CALENDAR_TIME_INFO,SQLSTATEMENTSOURCE,SELECT * from dbo.BPC_Time where Time = '%TIME_SET%')
PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)
INFO(%TEMPFILE%,%TEMPPATH%%RANDOMFILE%)
GLOBAL(OLSAPPSET,%Environment%)
INFO(OLSAPPSET,%Environment%) TASK(BPC Task Convert,INPUTFILE,D:\PC_MS\Data\WebFolders\%Environment%\FINANCE\DataManager\DataFiles\%ENTITY_SET%_%TIME_SET%.csv)
TASK(BPC Task Convert,OUTPUTFILE,%TEMPFILE%)
TASK(BPC Task Convert,CONVERSIONFILE,%TRANSFORMATION%)
TASK(BPC Task Convert,STREnvironment,%Environment%)
TASK(BPC Task Convert,STRMODEL,%MODEL%)
TASK(BPC Task Convert,STRUSERNAME,%USER%) TASK(BPC Task Dumpload,Environment,%Environment%)
TASK(BPC Task Dumpload,MODEL,%MODEL%)
TASK(BPC Task Dumpload,USER,%USER%)
TASK(BPC Task Dumpload,DATATRANSFERMODE,4)
TASK(BPC Task Dumpload,CLEARDATA,0)
TASK(BPC Task Dumpload,FILE,%TEMPFILE%)
TASK(BPC Task Dumpload,RUNTHELOGIC,0)
TASK(BPC Task Dumpload,CHECKLCK,1) TASK(BPC Task Logic,USER,%USER%)
TASK(BPC Task Logic,Environment,%Environment%)
TASK(BPC Task Logic,MODEL,%MODEL%)
TASK(BPC Task Logic,SELECTION,%SELECTIONFILE%)
TASK(BPC Task Logic,LOGICFILE,Default.LGX)
TASK(BPC Task Logic,CHECKLCK,1)