ContributionsMost RecentMost LikesSolutionsBI Viewer | Pivot Grid Formatting on Export Hi everyone! I am working with a Pivot Grid dashboard item in the BI Viewer. I am investigating about the possibility of formatting the Excel export of this component. Currently, the exported file d...Re: Work space Cubeview groups / row sharing Hi! Try to add a Namespace Prefix to the workspace, please see below an example: And then when linking the cube view for sharing the rows, refer to the workspace: Regards, Andra Re: FX rates retrieval – based on different source currencies Thank you everyone for the help! Big_Rick_CPM yes, I had to change my cube view. However, it would not have been helpful to display parent/child. Instead, I decided to use as entity only the parent...Re: FX rates retrieval – based on different source currencies This is the script from the member formula: Dim destCurrId As Integer = api.Pov.Cons.MemberPk.MemberId If destCurrId = Currency.EUR.Id Then Return 1.0 Else Dim rateType As FxRateType = api.FxRa...Re: FX rates retrieval – based on different source currencies Hi NicolasArgente Thanks for your reply! Unfortunately, it doesn't work. It brings the value 1 for all currencies 😞 Do you think there is any other option for this to work in a cube view? FX rates retrieval – based on different source currencies Hi everyone! I have two entity hierarchies, one in currency EUR, and one in USD. I need to create a cube view to retrieve the FX rates based on the parent’s currency. I’ve created an account, for...Re: Load FX rates through spreadsheet – Workflow time needed Hi NicolasArgente ! Thank you for the reply. Yes, this is one solution, initially I didn't want the user to have to select anything in terms of time 😞 But if there is no other workaround, I guess...Load FX rates through spreadsheet – Workflow time needed Hello everyone! I’m trying to set up an Excel spreadsheet to be used in a dashboard, for users to be able to insert their FX rates in the Workflow. I’m using the XFSetFxRate formula, and it works w...
