SQL Manipulation with a VB Net Variable
Hello, Does anyone know an effective way to alter the amount column of a table using a SQL script? Use case: the client is bringing in what they call "Production Downtime" to the system, which shows hours of downtime by plant based on a reason (attribute). Using a Dashboard Data Set rule, I created a SQL query to return specific results from the stage table based on Entity and Plant selections. This rule is linked to a data adapter and fed into the BI Viewer. In their BI Viewer report, it shows current Month vs PY Month. Since this data is coming in daily, when the user is looking at the current month, (today is Nov 21) the current month shows 21 days' worth of downtime data. They would like the PY Month to also represent 21 days of data. So, I would like to create a "ratio" variable that reads the current day of month and divides by the total days in month, and multiply the PY data by it. I created something similar in a UD8 calc: (SQL Is not my strong suit) how can I apply this "ratio" to the amount column of a SQL query? Amount * Ratio
Entity Relationship Properties update via business rules
Hi Team, I would like to fetch and update the Entity Relationship Properties for the Entity Dimension members via Business Rules. The below peace of code works fine for only when I pass the Actual and Budget but when i pass the other scenario Type like Scenariotype 1 to 8 I get the error Object is not set to an instance of an object. Dim Scenario As String = args.CustSubstVarsAlreadyResolved("Param_SecnarioType_EO_24") 'The above value i get it from the combo box as delimited list Dim Scenarioid As Integer = BRApi.Finance.Members.GetMemberId(si,dimtype.Scenario.Id,Scenario) Dim MyScenarioTypeid As ScenarioType = BRApi.Finance.Scenario.GetScenarioType(si,Scenarioid) Dim Timefilter As String = args.CustSubstVarsAlreadyResolved("Param_Time_24") Dim Timeid As Integer = BRApi.Finance.Members.GetMemberId(si,dimtype.Time.Id,Timefilter) Can you please help me with the correct way to get the scenario Type.
DashboardDataSet and DashboardExtender Business rules - parameter updates not refreshing
Hello, I am creating a dashboard with a grid view and gridview is binded to a Data Adapter which calls a business rule to get data thru an external web-api call. Now I have to show data in Gridview and the record count on the dashboard on a button click. I have used following settings on the button. The Selection changed server task is happening first and then the data load is happening, so I am able to update the literal parameters with counts after data load but they are not reflecting on the dash board. Any help appreciated.cashflow statement : Condition in the mapping of accounts
Hello OS community, I am currently developing my Cash Flow Statement and I want to add a condition for a loan account. If it has a positive balance in the Working Capital Requirement variation flow, I want to map it under one CFS table. However, if it has a negative balance, I want to map it under a different CFS table. How can I implement this condition in my Cash Flow Statement?
Dashboard Extender Rules - GetUserState / SetUserState Setup / Examples
We would like to get the POV that a user set in a Dashboard (through Form Templates) and apply it to each other dashboards that they go into. We use to call this a "Sticky POV". Currently, dashboards will hold the POV from the last time a user was in each dashboard. We want to carry the most recent POV into all dashboards. Does anyone have examples or know how to set this up / use it / access it...? Thanks in advance.Combo box not loading the bound list parameter
I trying to bind a combo box with bound list type parameter. The bound list parameter is using Command Type - Method and Method Type - Business Rule please see below screen shots. When I test the parameter it is showing results but combo box is not loading values on dashboard. Any help is appreciated. Sorry not able to attach images.