Extenders

220 Topics

Map source account to target account member and Ud4 member
Hi Everyone, I have a source file which contains multiple accounts in the columns for one month. These accounts are not there in the cube. I do not have a ud4 dimension in the source file. Each source account should be mapped to an account and Ud4 member. for ex: Account a001 has to be mapped to account A#a1 and Ud4#cost. Similarly Account b001 has to be mapped to account b#b1 and Ud4#sale. A#[a001]=A#[a1]:UD4#[cost] A#[b001]=A#[b1]:UD4#[sale] How can this be achieved in the transformation rule. Also, the data source needs to have ud4 or not. Thanks, Jeevan
Jeevan
12 days ago Place Rules
25Views
0likes
2Comments
Read a specific cell value from a Spreadsheet object
I have a need to read a cell value from a Spreadsheet object (Cell D3 to be specific) that will change the color of a button object in a dashboard. The cell converts color parameters to ARGB style, and I want to use this to show an example of the color in another object. Thoughts? I want the cell vale to set a literal parameter which will refresh the object
Mike_Sabourin
16 days ago Place Rules
12Views
0likes
0Comments
Service Factory - Data Management Step
We're moving most of the Business Rules to Workspaces Assemblies under PV 8.4. - We have several Extensibility Rules that are run by multiple Data Management (DM) Jobs like you. - Hence, we included separate DM Step Services (DMSS) in the same Service Factory (SF). - The result of this SF setup was chaos. - We saw that launching one DM Job by a given DMSS in the SF will also launch other DM Jobs by their DMSS in the SF. We couldn't find enough practical advice on the SF/DMSS setups in the Design Guide to overcome this chaos. Pls share how to set up Data Management Step Services in a Service Factory to launch one Extensibility Rule/DM Job at a time. TY.
KH1
18 days ago Place Rules
168Views
0likes
9Comments
One Button to Run several Data Mgmt Sequences in Parallel
Pls share how to use one Button to launch several Data Mgmt Sequences in parallel. - Not several Data Mgmt Steps in one Sequence. TY.
KH1
23 days ago Place Rules
105Views
0likes
6Comments
How to include Member IDs in data export
We are using an extender business rule to run FdxExecuteDataUnit and write the data (with dimensionality) to a file. The file generated seems to be a standard format with a column for each dimension. Does anyone have any ideas on how to include the Member IDs in the file export? Thank you, Denise
Solved
denisefockler
24 days ago Place Rules
115Views
0likes
8Comments
Corrupt file issue with BRApi.Utilities.SaveFileBytesToUserTempFolder
Hello We are using the BRApi.Utilities.SaveFileBytesToUserTempFolder command in a dashboard extender rule to open a file generated by IFS. It will create PDF or Excel files based on the extension of the file. When the user tries to open either file type they get one of the following errors. I am able to locate the generated file in my Temp folder but it won't let me open from there either. Has anyone see this or know of a solution? I am aware it is a MS issue probably not OS, but was just thinking there may be a new way to generate these files so MS doesn't think they are corrupted. The client is currently on 7.4.2. They had previously been on 6.8.1 but apparently have not used this dashboard since then. Thank you CR
creddick
30 days ago Place Rules
18Views
0likes
1Comment
OLEDB positional parameters with a WHERE IN clause
We have FX rates published in a table to/from virtually every currency in the world. However, this is something like 70k rates a month and the vast majority are for currencies we don't use in our OneStream application. The majority of the rest are for combinations that we don't use. Of these tens of thousands of rates, only about 25-30 are actually relevant. I'm trying to automate this filtering using the currency filter from the application properties, which returns a simple comma-separated list, like so: CAD,EUR,JPY,USD In this example, I want all rates to/from USD. So, I ditch the ",USD" and want to filter on the three remaining currencies: CAD,EUR,JPY Writing a query in SSMS, this is trivial. Writing the query with straight up string manipulation in the BR is also straightforward. However, I'm trying to be (perhaps needlessly strict/cautious) by passing this in as a parameter. This makes me want to use my laptop as a non-brand-specific flying disc and restart life as a hermit in a cave with no electricity. Un-typed positional parameters in an OLEDB connection are a nightmare (but probably because I need to learn more.) My basic thought is something like this: BRApi.Database.ExecuteSqlUsingReader(dbConnInfo, sql, params, False) SELECT FromCurrency,ToCurrency,Rate FROM FxRateTable WHERE (FromCurrency IN (?) AND ToCurrency = 'USD') OR (ToCurrency IN (?) AND FromCurrency = 'USD') I parsed the currency list to include single-quotes around the currencies and then just passed in P1 and P2 parameters as the same value so it should evaluate to a very normal WHERE IN clause. I get zero results from within OS. If I hardcode the list of currencies (comma-separated with single-quotes) in place of those ?s in the BR, the code succeeds and updates the rates in my OS application. I can only assume there's some type of data type problem that isn't making the translation through the OLEDB driver. I can conceive of a several possible avenues of investigation: There's a way of passing in these currencies as a string and I'm just doing something wrong that should be obvious. I need to add data-typing code in the BR (and perhaps store the currencies in a compatible data type) for OLEDB to play nice. I switch all of our external DB connections to SqlServer native so I can pass in named, typed parameters. (In this case, the docs only have instructions for setting up OLEDB, not native SqlServer. Does anyone have info on this?)
Solved
photon
31 days ago Place Rules
31Views
0likes
3Comments
FDXExecuteCubeView
Hi, I am working on extracting data from a Cube view to a flat file. I am using FDXExecuteCubeView query to extract. The extract file is executed to run for one year. I am seeing for each Entity, Scenario, Time (DU) a log entry is created in Task Activity. The Task Activity is getting flooded with cube view log entries. Is there a way to stop the Cube view entries for each Page (Entity, Scenario, Time).? On the Cube view I have the log setting set to False and also in the FDXExecuteCubeView setting I have the logStatistics setting set to False. Is there a way to not log the entry for each time cube view is run for (Entity, Scenario, Period)? Appreciate your inputs!
hbindu
2 months ago Place Rules
29Views
1like
0Comments
Calling a WS Assembly from Dashboard
Hello, I am trying to execute this assembly at load time for this specific dashboard. The rule executes as expected, but I cannot seem to get the parameter to function properly. Here is how it is returning in the log: It's as if it is not reading it as a parameter at all. Any suggestions?
danszczepanski
2 months ago Place Rules
33Views
0likes
3Comments
SQL Table Component Not Defaulting
Hello, Something a little different here. Below is an OS Dashboard. The client is leveraging SmartLinks to navigate specified users here (via Email). Upon selecting the link, the user is navigated here on the browser. The first red box indicates the Project to select. SmartLinks allows this to be prepopulated so the dashboard is defaulted with the correct information upon arrival. Everything is working as expected besides the pesky SQL table editor component. Web View: It is important to note that the SQL Table Editor component is populated via Dashboard Extender rule, which is executed when the Project is selected. In this case, the project is already selected, but I cant seem to get the extender rule to execute upon arrival to the dashboard. Any ideas? I want to believe this is less with the new SmartLinks feature and more with standard OS logic.
danszczepanski
2 months ago Place Rules
11Views
0likes
0Comments