-
Is it possible to have no totals for certain algorithm blocks in the total line of a dataview.
I have a dataview with total lines but besides "normal" data I have a column with a algorithm block showing percentage values in a tooltip (as information for the user, so that he know which maximum percantage value is allowed to be entered) - for this percentage values in the tooltip I dont want to see summed up totals,…
-
Hint in dataview
Is possible insert in a dataview different hint for each column header?
-
Problem Loading images with Data entry
Hi everybody, I’m currently struggling to upload some images into a BLOB cube. I already have a cube containing different items, and I’d like to associate each item with its corresponding image. To do this, I created a BLOB cube with the same dimensions as the original one. Then, in a Data View, I tried to enable the Data…
-
Year-End Value While Retaining Month Drilldown
Good afternoon, I am trying to create a graph that displays the year-end value. At the same time, I want to maintain the ability to drill down by month and see all the preceding monthly values. Does anyone know a method to achieve this in the graph? Thank you.
-
Color Alert
Hi, I would like to apply a color alert. I have created an true or false formula which is used in the color alert. when I have true or false formula unhidden the alert works but not when it is hidden. Any idea what I am doing wrong?
-
Flex Grid - Opening fully collapsed
Note - Ignore this, found the solution! Is there a way to configure the flex grid so when you load the screen it loads fully collapsed to enhance speed?
-
Level 300 : 305 Functional Test
As far as I can see, I have completed all config as per instructions and I have gone over them to recheck and confirm. I am however missing data on the first question in the functional test. The test suggests there should be data for products Classic, Double Halo and Grey Pearl Stud as below. I however, only have data for…
-
Performance analysis tool to find out why a dataview report loading very slow?
Hi BOARD team, I built a simple data view report using Tab. Couple of tables are loading much slower comparing to others. The table is simple and highly summarized. Is there a tool in BOARD we can use to find out why certain reports take much longer to load? Thanks a lot
-
Level 200 : 210 No Data on Expense Planning Data Views
Hello, I am struggling to populate data into both the Annual and Monthly Data views. I have gone through all the steps again. I have also re-run all data readers and the BUD - Initialize Budget procedure, but my view is still empty, and hence failing functional testing. My currency selector also shows 2/2 instead of 1/1 as…
-
Best practices how to show many columns in dataview (>10 columns with a hundred thousands data rows)
Hi all, I want to know the best practices how to show many columns in dataview with approximately >10 columns with a hundred thousands data rows in a dataview. Because I am stressfull a lot about limitation error rows limit issues. I have read many references from other forums/discussions about this one, and overall of…
-
Aggregate functions for Board Cubes
Hi, if you display a Board cube in a DataView and group it by an entity, then a sum is always formed for the values from the cube. Is there also a way to form an AVG(), MAX() or MIN() on the individual values instead of the sum, so that an average or a maximum value is obtained from the individual cube values? I would like…
-
Calculate Mix including Subtotals
Hi there, how can I calculate percentage mix including subtotals? At the moment it is calculated by group. The algorythm formula GT doesn't work since I have Years in the columns and it does the math for the sum of all years. However I need it by year. Thanks maik
-
Sorting in Data view with Detail by
Hi can someone shade some light into sorting logic with "Detail by" activated? a - is on the first spot and Detail by Year is activated - However it isn't shown in the preview When I move it to spot - b - I can see Occ TY by Year - However now the order of the other columns is screwed. Any idea how to fix this? Thanks Maik
-
Maximum Data Blocks within a Data View
This takes me back to excel days. I'm currently at FD with data blocks and I'm blocked from adding any more in. Is there an upper limit? Has anyone had this same issue or never gotten to this many blocks? Build is in B14.2. I'm trying to add algorithms in not additional data blocks. Doing this with right-click add rather…
-
Issues with 'Detail by' sorting feature
This issue has popped up in the layout editor after I added an entity in the configure drill down. The data is tying out correctly for all my data blocks, the only issue now is when I try to drill down on a specific P&L line. The drill down shows every member in the entity rather than the specific line I am trying to drill…
-
Dynamic Visibility of a cube / data block in a data view
Hi, is there any possibility to steer the visibility of a cube / data block in a data view? I want to achieve that I can steer on an admin scree, if a certain cube/data block is visible in a data view on another screen. I know that you can steer the dynamic visibility of the whole data view, but I need it for a certain…
-
Loop function doesn't work
Hi all, I'm trying to do a loop calculation, but for some strange reason some of the numbers don't add up the cube has 2 dim (month and Drivers in blue) the first member of Drivers (baseline) has only the value in the first month, while for driver "a" "b" "c" i can data entry after the first month my goal is to copy the…
-
Skipped rows of Cube value of 0
Hi guys, I have some issues that have skipped rows of Cube value of 0 but in Data Reader ETL is displayed well. I have unchecked Hide zeros and checked differentiate zero and null. Anyone have some ideas or solutions about this one? Thanks previously