-
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
-
Blob Cubes (Custom) Upload and Download Functionality
I'm creating a screen within our business planning capsule that will be a single data view object intended to store various file types that offer supplemental information over what's provided in the business plan. I would like for the file inputs to be heterogenous, so that I don't have to create a cube specific to the…
-
Column Entity Always Show the Total Members and Not Display the Actual Value in Dataview
I want to know the causes of why my Part Number column entity always show the total members and not display the actual value? Did I have some mistakes in mapping my cubes? FYI : Cube (Mixing Ratio)→ Have 3 entities mapped into it (Part Number, Plant FG, Supplier/Cost Center) And here captures of my settings in Layout…
-
Block showing only sum total
Hi everyone, Is it possible for a block in data view to only display the sum total? I've tried using the algorithm rt(j) but the variance total is incorrect, i.e. I want the total variance to be -7,425.5k, not 325,424.6k. If I take away 'Detail by Month' in block j, the variance calculation is wrong. In essence, how can I…
-
How to find maximum value of cube or entity in Layout Editor?
Hi guys, I have no idea about how to find maximum value or calculate this formula inside Layout Editor Dataview : "Max of Price In IDR (Current Month) = MAX(Price In IDR) WHERE BOM Period = Current Month" I will appreciate your helps for this case. Thanks.
-
Algorithms
Hi, is there a possibility / syntax to refer a algorithm block (using the formula “rt(x)” or “dt(x)”) to only one or more certain columns and not to every(!) column of the entity that is set in the column axis? Can somehow specific entity members be adressed? I want to achieve that there are different color alerts for…