The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
particle
3 years agoNew Contributor II
FdxExecuteCubeView parameters
If I build a cubeview that contains the desired POV and functions on its own, using FdxExecuteCubeView seems to work great. However, there is no documentation available on actually using the FDX func...
- 3 years ago
You're not missing anything obvious, it's the documentation that's missing...
From some internal resources, i see a comment like this over all the "filter" parameters of FdxExecuteCubeView:
'when the extracted cube view references an entity parameter called |!FDXEntity!|, this field needs to be set to the name of the entity dimension the extracted entities exist in 'if the cube view does not use an entity parameter called |!FDXEntity!| then this field can be left blank "" or as String.Empty Dim entityDimName As String = args.NameValuePairs.XFGetValue("", String.Empty) 'when the extracted cube view references an entity parameter called |!FDXEntity!|, this field needs to be set to an entity member filter that controls the extracted entities based on the member filter 'if the cube view does not use an entity parameter called |!FDXEntity!| then this field can be left blank "" or as String.Empty Dim entityMemFilter As String = args.NameValuePairs.XFGetValue("", String.Empty) 'when the extracted cube view references an scenario parameter called |!FDXScenario!|, this field needs to be set to the name of the scenario dimension the extracted scenarios exist in 'if the cube view does not use a scenario parameter called |!FDXScenario!| then this field can be left blank "" or as String.Empty Dim scenarioDimName As String = args.NameValuePairs.XFGetValue("", String.Empty) 'when the extracted cube view references a scenario parameter called |!FDXScenario!|, this field needs to be set to an scenario member filter that controls the extracted scenarios based on the member filter 'if the cube view does not use a scenario parameter called |!FDXScenario!| then this field can be left blank "" or as String.Empty Dim scenarioMemFilter As String = args.NameValuePairs.XFGetValue("", String.Empty) 'when the extracted cube view references a time parameter called |!FDXTime!|, this field needs to be set to a time member filter that controls the extracted time periods based on the member filter 'if the cube view does not use a time parameter called |!FDXTime!| then this field can be left blank "" or as String.Empty Dim timeMemFilter As String = args.NameValuePairs.XFGetValue("", String.Empty)So I assume those fields do nothing unless those Parameters are present on the cube view.
Sergey
OneStream Employee
3 years agoHi ! I'm sorry to dig into this topic, but I get the same error : I have the entity dimension set as a parameter in my cube view POV : |!DashBoardEntity_Exec!|. It's an input parameter with only "Houston" in it.
This Cube View with this parameter will not work. However the same cube view but the POV set as 'Houston' (without the parameter then) will work.
What is the configuration needed with these |!FdxEntity!| ?
- particle3 years agoNew Contributor II
This parameter only works if you're calling the cube view using the FdxExececuteCubeView function from a business rule. It's not used if you're looking to just execute a cube view for normal reporting situations.
FDX functions are for "Fast Data eXtracts" so they're useful if you're looking to do exactly that but they're difficult to leverage because there's no documentation. This thread is the most information I've ever seen on one and it's still missing a lot to properly leverage it, not to mention all of the others.
Related Content
- 2 years ago
- 4 months ago
- 2 years ago