ContributionsMost RecentMost LikesSolutionsJoin Application Tables with External Database Tables Hello - I have a SQL data adapter that connects to an external database for data loads, dashboards, etc. Is it possible in the query to join these external tables to tables in the Application datab...All Months in Prior Year based on Global Time Hello. I am trying to create a column set showing M1-M12 for the previous year based on Global Time. I can do this successfully using WFYear and POVYear as shown: T#YearPrior1(|WFYear|).Base T#Y...SolvedMaking calculation logic and equations visible to end users Hello - Wondering if anyone has come up with a efficient way of providing visibility for end users into the calculation logic and/or equations that are being used by dimension members. For example:...Dimension Look-up during Transformation We are trying to develop logic to do the following during transformation: If the G/L account in the load is in a certain range and the UD2 member is valid, load to that intersection otherwis...Re: Keeping the 'focus' on the current tab in a multi-tabbed dashboard This post might also be relevant to your situation. Good luck. https://community.onestreamsoftware.com/t5/Application-Build/Dashboard-Refreshes-on-Tabular-Layouts/m-p/7342 Thanks, Bil Re: Making calculation logic and equations visible to end users Great suggestions - thanks for your response! Thanks, Bil Re: How to update Global Time dynamically via BR I added this code to a Data Adapter: UPDATE AppProperty SET TextValue = '2022M10' WHERE Name = 'GlobalTime' After executing the query, the value in the AppProperty table is changed, but t...Re: Execute Stored Procedure on External Database Hi, Oscar. Are you getting an error? If so, please attach it to this thread. Two thoughts: 1) Does the user have EXECUTE permission on the dbo.usp_GLReport stored procedure? 2) Are you entering th...Re: Dashboard: Combo box with bound parameter Hi, Lee. I'd appreciate the info as well. When you have a chance, can you send to bbrandon@ecapitaladvisors.com? Thanks, Bil Re: Displaying Text Values in Cubeview This is a simple query of the OneStream Application database. Just two tables: Member (Aliased below as M) MemberProperty (Aliased below as P) Query: Select M.Name, M.Description, Min(Case ...
