Announcement
ABCRecent Activity
Business Rules Implementation
Hi, I'm trying to learn more about the business Rules and what they are doing. Where can I find the various function implementations. For Example: I have this function Dim connectionString As String = GetConnectionString(si, globals, api) For the GetConnectionString function where is the code for this funciton ? so I can read and understand what its doing ? If this is in the API, I have been looking there today, can you reference which folder / document I can get this. Thanks for your help in advance.
Time Profile: Time dimension at week level vs at month level with weeks in UD
Hi All, I am designing a new app with huge data set at detailed level and need time at weeks level. I would like to know if going by custom profile with time dimension at weeks level would be more efficient or having time dimension at month level and using WEEKS in User defined dimension would be better in the performance. It would be great if you can share some pros and cons for both the approaches and which one would be optimistic. Thanks in advance.
Updating book via Excel OneStream Add-in
Hello, everyone, I created book in OneStream, which includes several cube views, and open this book in Excel OneStream Add-in. Could you please advise can I change some parameters in this book, for example Time member, and refresh all cube views in this book in order to received updated figures based on new parameter? Or it's not possible, because books which I open in Excel OneStream Add-in, contains only values and if I want to update reports via Excel OneStream Add-in I need to create quick views in Excel OneStream Add-in?
Bug - Report 40c1 (Sch 10) - Wrong Year Parameter
This relates to releasePV7.3.0 SV100. You will need to apply this fix to the OpenPlace solution. Issue: Each column in the report (Cube View: 40c1 Sch 10 Nat Any Entity_TXP) uses the parameter "WFYear". This needs to be changed to the parameter "|!Select_Year_TXP!|". Cube View Changes: 1) Remove the Time Member reference in the POV - it is not needed. Before: After: 2) Update each column header for the time period. Replace "T#WFYear" with "T#|!Select_Year_TXP!|" Before: After:-- START HERE -- Links to the "Key" KB articles -- Tax Provision
Here is a list of "KEY"KB articleswith links. Many of the below KB articles contain links to other KB articles. Summary of the Tax Provision Functionality by Version What Types of Tax Provisioning Can Be Done Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100 Miscellaneous Information - Package Content Naming How to Import the Tax Provision Blueprint app in a Dev Environment (Step 1) How to Setup the Tax Provision Blueprint app in a Dev Environment (Step 2) What are the Necessary Activities to Start a New Tax Provision Year - "Actual" What are the Necessary Activities to Start a New Tax Provision Year - "Forecast" How to Save your Tax Provision Cube POV Where are the Tax Reports? How do I Get to the Tax Reports? SAMPLE FORMS -- Links to all the Sample Forms KB articles Design Assumptions Glossary Tax Cube Setup - XFW_TXP Create New FX Rate Types Metadata Components - Overview Business Rules - Overview Home Page Reports Sample Reports - Overview Data Integration Dashboards Schedules & Reports - PPT Help Files Workflow Forms/Schedule Notes Workflow Profiles Form Templates Cube Views Parameters Security Troubleshooting the Schedules Debugging a Dashboard Error Message - Cannot Determine the CubeRoot Profile that Workflow Profile [XFW_TXP_NotUsed] Bug - Schedule "03 FC Tax Attributes" - Linked CV Bug - (v8.0 & v8.1) - Load/Extract Screen - Extract Exceeds File Size Limit Bug - Schedule "06a Deferred Tax" - Input Open on Tax Losses and Tax Credits Bug - Schedule 07 Tax Account Reconciliation Translation Rule Bug - Translation Issue with Account "TXP_TxRperGL" Bug - Report 40c1 (Sch 10) - Wrong Year Parameter Is Tax Provision Upgradeable? Is Tax Provision Compatible with Version 8 (v8)? How Do I Know What Version of Tax Provision I Am Using? Adding the Refresh Button To a Toolbar Using a Time Profile With Weeks Remove the Word "Blueprint" Data Copy - What Happens When Different Entity Currencies are Involved? How to Create a "Sort" Check Box in our Dashboards (used in schedules or reports) Activating the "In Use" Metadata FeatureConsolidation- Calcstatus showing CN for all period.
Hi Everyone, We recently migrated from 7.1.3 to 8.4 . after migrations, we are facing issue in Calcstatus- Consolidation from Bottom to Top ( Parent). we tried to consolidated-calcstatus from beginning of the data to till now. But its not running properly or not showing value in parent level. after closing cubeview again its showing CN. is there anyone faced this issue and find the solutions?
Weekly time application
Dear Community, Since I can create a weekly calendar using a customized Time Dim, what is the "Fiscal Year Month Type" such as Fixed week 4-5-4, 5-4-4 in the time profile used for? If it is used for fiscal year purposes, how can I see the impact? I tried to play around time profile, and it doesn't seem to impact anything. Please provide some ideas. Thank you
Issue with Removing Period Selection When Data Value is removed from a Text property
I am attempting to update the "text" property (which varies by time) for my UD1 members using a business rule that pulls data from a custom table. The update process works as expected without any issues. However, when I remove a data value from the table, OneStream removes the value from the text property, but the corresponding period remains selected, showing blanks (see Screenshot 2). I am removing the data value using the "Else" condition as shown below (Screenshot 1). Can anyone provide insights on how to also remove the period from the selection when there is no value? TIA Screen Shot 1: Screen Shot 2:Is there a way to hide the OnePlace Pane?
A client doesn't want some users to see the OnePlace Pane and just navigate based on their landing page. There is an application security role for it and I updated that group to a specific group so its not set to everyone. When I test the user role that doesn't have the OnePlace Pane in their security roles, its not working and the OnePlace Pane is still showing up?
