Sai_MagantiContributor IIJoined 4 years ago111 Posts60 LikesLikes received15 SolutionsView All Badges
ContributionsMost RecentMost LikesSolutionsRe: Threshold Operation in FDX using SQL Query Hmm not sure why it is not honouring the filter..However, you can ignore the filter here and fetch all the data and then do a select on the datatable returned. See above post by OP. The filtering was...Re: Threshold Operation in FDX using SQL Query Assuming that there is data for that Account and UD1 combination, I don't see any reason why it shouldn't work. I had done similar filters and they are working fine in all versions upto 8.2. Not th...Re: CubeView Performance - OneStream Dashboard Vs FDX Use the following filter. The Tops don't work. You can only filter for base members. If you need to filter the 'None' for UD7 and UD8 add them. Filter = "UD2='LE00037' AND UD3='200020' AND Account ...Re: CubeView Performance - OneStream Dashboard Vs FDX Have you tried using FdxExecuteDataUnitTimePivot rather than FdxExecuteCubeViewTimePivot? I was able to extract circa 220K records with all the base Dims and 12 time columns using the data unit pivot...Re: Threshold Operation in FDX using SQL Query If you meant that you're running an FDX query and want to see values > 30000 in the returned datatable then you can use the Filter parameter filter = "Amount > 30000" BRApi.Import.Data.FdxExecute...Re: How to calculate values of the same column in the Calculated Field You might want to try this: Create 3 calculated Items Item1 iif(Col1Hdr0NameAndDesc = 'Some Val', SUM(Col0Value), 0) Item2 iif(Col1Hdr0NameAndDesc = 'Some Other Val', SUM(Col0Value), 0) Ite...FdxExecuteCubeView Function What is the purpose of timeMemFilter, entityMemFilter and scenarioMemFilter parameters for the below function as these will be defined in the cube view? Is there a way to extract aggregated membe...Account dimension member "In Use" property Account dimension member "In Use" property (Vary by Scenario Type and Time) set to Scenario Type = "Control" and Time to "2022M2", Stored value "False" However when I try to grab the InUse va...SolvedRe: OneStream - NetSuite We used SuiteAnalytics Connect for the integration (direct connection to Netsuite using ODBC) with some custom SQL queries to pull in the transactions into OneStream. SuiteAnalytics Connect exposes N...Re: REST API USE Sridhar I used this in a connector BR to import FTE actuals from workday. Best Sai
