We are under construction!
You may experience downtime, errors or visual oddities, but we anticipate all will be resolved by the end of the day.
Metadata
206 Topics
Hybrid copy scenario not coping only USD value for non usd entities
Hi , i am trying to copy between scenario through hybrid copy scenario feature but i observer that wherever only USD value present for non USD entities , data copy not happening. could anyone please suggest if anybody come across this scenario.64Views0likes2Comments
CellStatus retrieves a different status than shown in the Cube View
Hi all, I'm trying to build a CV with Entities on rows and Scenarios on columns that will show the status of the cell with the help of a Dynamic Calc. Here's the aspect of the CV (Scenario and UD8 on columns): TEST is my dynamic calc (also crossed with V#Annotation so it can display text). As you can see, I can write on U8#None and yet the dynamic calc returns READ. Here's my code: Dim sEntName As String = api.Pov.Entity.Name Dim sScnName As String = api.Pov.Scenario.Name Dim sStatus As String = Api.Data.GetDataCell("Cb#CORP:E#" & sEntName & ":C#Local:S#" & sScnName & ":T#2018M1:V#YTD:A#ADDUG:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None").CellStatus.ToString brapi.ErrorLog.LogMessage(si,"sStatus = " & sEntName & " - " & sScnName & " - " & sStatus) If sStatus.XFContainsIgnoreCase("WriteAccess: False") Then Return "READ" Else Return "WRITE" End If Here's the POV of the first cell (on E#3002:S#Actual): Cb#CORP:E#3002G0:P#?:C#Local:S#Actual:T#2018M1:V#YTD:A#ADDUG:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None And this is the Cell Status shown in the CV: However, the CellStatus that I'm retriving with my Dynamic Calc says the following (I highlight the incongruences in RED😞 Description: sStatus = 3002G0 - Actual - StoredBits: 33, DerivedBits: 264, ExistenceType=IsRealData, StorageType=Input, NoDataZeroViewOverride: Default, Invalid: False, Error: False, IsDefaultFreq: False, ReadOnly: True, ReadAccess: False, WriteAccess: False, CanCalculateFromGrids: False, IsLocked: False, IsFromCalcScript: True, IsDynamicCalc: False, IsCalcStatus: False Does anybody have any clues why the CellStatus looks different between the script and the CV? Thanks, GSFSolved362Views0likes3Comments
8.4 Dashboards for phone, tablet, web and windows App
Hi All We are using 8.4 at our new client and have been tasked with creating dashboards suitable to view on a tablet, web, windows app and phone. We have created different dashboards for each of the different devices, i.e. tablet, phone, windows app and web but have noted that for example, the phone dashboard formatting shows differently on each phone, depending on the phone screen size and it does not auto adjust to fit the screen size of every phone. Same as for tablet, web and windowsApp. Where can I get settings for auto fit on each device so that it shows uniformly on each device regardless of screen size?223Views0likes3Comments
Remove Alt Hierarchy Parent-Child account without removing from the original Heirarchy
Hello, I mistakenly added a sub parent along with 3 base accounts to an alternate hierarchy. Is there any way to remove the parent child relationship in the alternate hierarchy without removing it completely from the original hierarchy?111Views0likes1Comment
Count ZeroDataCells by Account Dimension Member
Is there a way to determine the number of data cells by account-type dimension member? In our example, we are reviewing an implemented application with millions of ZeroData cells and are trying to identify which account formulas are producing the most zero data cells. System Diagnostics has a "Data Volume Stats" tab that lists data cell status counts (i.e., RealCellCount, ZeroCellCount, etc) by data unit. However, there does not appear to be any reports that display this information by account. Has anyone had success retrieving this information via a different application report or custom SQL query (against the application database)? This is probably unrealistic to retrieve (given the data volumes required), but maybe there is a way I haven't yet considered.Solved353Views0likes4Comments
128Views0likes0Commentscreate replication Hierarchy
Hi OS Experts: I have an existing hierarchy called "ControlMgt Hierarchy," which has several rollups underneath it. I need to recreate a new hierarchy named "ControlMgt Hierarchy_ALTERNATE," where "_ALTERNATE" will be added to all the rollups. The base elements will remain the same between the two hierarchies. I’m considering exporting the "ControlMgt Hierarchy" and updating it to include "_ALTERNATE" for all rollups in the XML file, and then importing it into the entity dimension. Is this possible? Will this create a new hierarchy, or will it overwrite the original hierarchy? Could you please suggest the best approach to accomplish this?198Views0likes4CommentsHow to place multiple UD1 members in Account dimension UD1 constraint
Hello OneStream experts: Thank you for the helps in the past. I have a quick question about placeUD1 members in Account dimension UD1 constraint For example: In my account metadata dimension: I have 2 accounts 4001-Sale_IceCream 4002-Sale_Donut In my UD1 product dimension: I have 4 products all under one parent product Product_1,Product_2,Product_3,Product_4 I want to placeProduct_1, and Product_3 to the UD1 constraint in account4001-Sale_IceCream's UD1 constraint field. But OneStream only allow me enter one product member in that filed. I can only enter Product_1 but cannot enter both Product_1 and Product_3 in the field. Thank you so much in advance to help me get through this issue.149Views0likes2CommentsScenario Type - Tax
Hi, What are the major considerations that need to be looked at before making a design decision for implementing "Tax" Scenario Type? What are the pros and cons of using this Scenario Type vis-a-vis "Actual" Scenario Type? Is there any guidance/ knowledge post on the same? Use Case: Want to integrate an erstwhile Tax application into OneStream Application where actuals are already available. The tax application has some additional tax related dimensions, rules, etc. which need to be used in OneStream.125Views0likes1Comment