Member Filter on Scenario properties
I would like to apply a member filter on a scenario, which will return a list of a scenarios based on it's properties like Name, Description, WorkflowTime, WorkflowStartTime, and WorkflowEndTime...i.e. WorkflowTime = |someYear| or WorkflowStartTime = |someYear| or WorkflowEndTime = |someYear| I can do this S#Scenario.where(Name contains paramScenario) I can do this S#Scenario.where(Description contains paramDescription) I cannot do this S#Scenario.where(WorkflowTime = 2025) I cannot do this S#Scenario.where(WorkflowStartTime = 2025) I cannot do this S#Scenario.where(WorkflowEndTime = 2025) What am I missing?Solved28Views0likes4CommentsHybrid 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.67Views0likes2CommentsCellStatus 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, GSFSolved376Views0likes3Comments8.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?226Views0likes3CommentsRemove 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?114Views0likes1CommentCount 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.Solved354Views0likes4Comments- 128Views0likes0Comments