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.
Forum Widgets
Recent Discussions
Use POVPrior1 in XFGetCell?
Hi, I am using an XFGetCell Formula which references the POV for Time. I would like to use a formula to pull in the period prior to the POV in the same worksheet and keep it dynamic based on the POV. Any suggestions? If it's not possible to do in the formula, I will need to create a UD8 to return the prior period time. Does anyone have a ready-made formula for this? I would greatly appreciate it! Thanks! Thanks!SolvedNAS21 hours agoNew Contributor III77Views0likes2Comments
Basic Question about BI Viewer and Cube View MD data source Column Expression
I have a Cube View with three Account dimension columns - Net_Rev, Std_Cost, and a CVC calculated division column to calculate Std_Margin (Std_Cost/Net_Rev). Rows are a UD dimension representing the Product. In my Dashboard, I have a Cube View MD Data Adapter using this Cube View as the data. When I add a BI Viewer Pivot Grid, I want to display the same three columns - Net_Rev, Std_Cost, and the calculated column. I see CalcScript in the Pivot Grid's Data Source dimensions. How do I use it in the Pivot Grid to display the calculation that the Cube View was doing for that third column? I thought I might reference it in the Value filter along with the two Accounts, but it doesn't appear as a column in the Pivot Grid.KurtMayer2 days agoContributor79Views0likes3Comments
Creating a Conditional Statement within a Cube View
Need assistance building this logic in for two conditional statements to return a value. The logic reads if one row is greater than 0.20 and another row is greater than 0.20, then 0 is the cell value. If not, then 1 is the cell value. Please let me know if I can provide any additional details.emantziaris2 days agoNew Contributor46Views0likes1Comment
Using of Text field on Entity dimension in Cube view
Dear all, Could you please advise how to show Text field of Entity member in cube view instead of Entity Name. For example, I have: Entity member with Name A, it has Text1 field Country 1, Entity member with Name B, it has Text1 field Country 2 Entity member with Name C, it has Text1 field Country 2 I would like to show in cube view in rows figures on Country 1 and Country 2 (so I need to aggregate figures of Entity B and C in this row). Could you please advise is it possible? If it isn't possible to aggregate figures, could you please advise if I can simply show three rows Country 1, Country 2, Country 2 in cube view instead of Names.SolvedIrina2 days agoNew Contributor II117Views0likes5Comments
Carriage Return in Annotation data on Cube View
Hi All Does anyone know how to add a carriage return in Annotation text (if it's possible)? We have a Cube View with an annotation member that displays data. Currently the annotation text can take up most of the screen on some rows andit would be really useful to be able to enter a carriage return. I have tried Environment.NewLine, vbCrLf, \r\n, <br>MarcusH2 days agoContributor III31Views0likes0Comments
CV: columns with master data displayed
Hello, it's probably simple question to solve, but I wasn't able to find a solution. Is it possible to display the dimensions (master data) of the query in the cube views? e.g. columns, CV should generate atable with the following: Account | Amount | Cost Centre Number | Cost Centre Name | Profit Centre | Profit Centre Name | ... and so on. I have tried it via UD (where the information is located), but I only get the amounts, but not the elements/master data/dimension or description. What am I doing wrong? Thank you!SolvedLucaR2 days agoNew Contributor II157Views0likes2CommentsReport Book - Loop with a XFBR string
We are looking to turn some of our existing cube views into report books to loop through entities. Right now we use an XFBR string (referencing Brapi.Workflow.Metadata.GetParent) instead of a parameter to determine the entity. Is it possible to create a report that loops through the entities with the XFBR string or would we have to duplicate the cube views and use a parameter instead?JuleneDS2 days agoNew Contributor II39Views0likes1CommentConstraints Reports by Dimension
Are there any out box reports available to show constraints by dimension?Solvedpranav462 days agoContributor II106Views1like4Comments
Narrative Reporting
Hi, We have installed NRR and are able to upload documents. However, adding a cube view using the syntax is not working. Despite searching related articles and trying different syntax variations, the cube still fails to render: Syntax 1: {DOCVARIABLE "{XF}{Application}{CubeViewReport}{Abseentism_Rep}" "IncludeReportMargins=False" "IncludeReportHeader=False" "IncludeReportFooter=False" "IncludePageHeader=True" "IncludePageFooter=True""} Syntax 2: "{XF}{Application}{CubeViewReport}{Abseentism_Rep}" We are on V8.2.2, does anyone have any tips?Tracy6 days agoNew Contributor100Views0likes1Comment
Tags
- Cube View615 Topics
- Reports427 Topics
- Dashboards335 Topics
- Excel Add In234 Topics
- Parameters103 Topics
- BI Viewer78 Topics
- Books69 Topics
- annotations25 Topics
- Extensible Documents25 Topics
- Fact or Fiction Trivia24 Topics