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.
Application Build
Workflow and Data Integration
Rules
Reporting
French Language Forum
Recent Content
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!Solved71Views0likes2Comments
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.74Views0likes3CommentsTask scheduler skipping date
Hello, Has anyone seen this before where the task scheduler looks as if it will skip a date? Under the grid view, the autoloads highlighted are skipping 10/1/24 even though they are all set to run the first and the second day of every month. Weirdly enough, under the calendar view, they are listed correctly under 10/1 date column and after a few switches back and forth it reset itself back to 10/1 without any other action. Any idea would be appreciated.
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.42Views0likes1Comment
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.Solved116Views0likes5Comments
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>26Views0likes0Comments
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!Solved155Views0likes2CommentsReport 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?37Views0likes1Comment
