-
200: module 203, Section 11ff, Data reader for Data Cubes is not working
Hi, I have set up the data cubes in Section 11 and 12 and when I added the data reader in section 13 I made an mistake by adding only the 5 entities from screenshot to the reader, leaving out cube data fields. In Section 14 I noticed I do not have data in my cubes, even when the reader said it had loaded it. I found the…
-
B14 Level 200: module 203, Section 11 to 13
Hi, I have set upped the Cubes and the data reader but when I run the reader nothing happens. At first I have build the reader analog screenshot and the two cube values were missing (unit and sales LC). Before the fix the reader worked fine but I did not had data shown in section 14. So I went back and noticed my failure.…
-
Missing Feb 29, 2024 Data in Prior Year Comparison
Hi all, We have identified a recurring issue in our Board environment where the 29th February 2024 sales data is not included when the user selects Prior Year (PY) for 2025. As a result, the reported sales for February 2024 are understated compared to the actuals shown when directly selecting 2024. I am aware that Board…
-
Level 200: Module 211 and 212 after completing 211 and functional test not able to view data
-
Module 212: Not able to view the values after Update P and L
Previously i had pasted all the screenshots regarding the issue, one thing i noticed now is after completing all the processes , the screen is popping results of 2024. But according to the steps it should be of year 2023. Is there any problem with the year. if i select year 2023 in the play mode i am getting values similar…
-
Level 200: Module 212, I am not able to view the data after validating Update PandL
Based on the previous reply I confirmed all the procedure and layout of the cube the size is 0kb and double checked everything. One thing i noticed was in sales planning i am not able to view the data (it is popping a message as No series). I have attached the screenshot of that also, please help me with this issue
-
Level 200: Module 212 : I am not able to view the P and L screens Values, it is displaying blank.
I have attached all the screenshots please help me with this
-
Capsule Procedure vs Datamodel Procedure
1. Abstract While developers are facing procedure creation, they need to understand when it is appropriate to use data model procedures vs Capsule procedures. 2. Context As developers, it is our responsibility to always keep the long-term maintainability of our solutions in mind. Procedures must be developed in a…
-
Article How to loop procedures
Hi, Just reading through the article : How to loop procedures One part says Loading the extracted sequence into the Enumerator Cube so it looks something like this: How do I load data into a Temporary cube? Via the Data Reader I cannot see them. Thank you Maik
-
About Sparsity
Hi Team, I am reading the Best Practice Screen, which suggests that version / scenario can be set as Dense to improve speed. Just for the learning purpose (not means I will change it), we should review the folloing Sparsity? Thanks
-
Clarification on “Max Item Number” when creating an Entity
Hello, I would like to ask for clarification regarding the Max Item Number option when creating a new entity. When the Max Item Number is set to Auto, what exactly does it mean? Does the entity accept an unlimited number of members? Or is there still a hidden system limit that we need to be aware of? I want to better…
-
Possible to load unbalanced hierarchy throught smart import ?
is it possible to load an unbalanced entity throught smart import ? Because i can't find de parent code in the mapping part
-
Charge unbalanced entity with datareader
Hi community When i want to charge an unbanlanced entity with my datareader , i always have one rejet for the parent code not found and in the relationship part i find that the parent code is missing , do you know where comes from the problem?
-
Trigger a Board Data Model Procedure from Excel Add-in
Hi All, Has anyone tried to trigger a Data Model procedure from Board Excel add-in using an API or any other approach? Regards, Vikash
-
Google Doc Connection
Hello everyone! I have a question: does anyone know if it's possible to establish a connection between Board and Google Docs? I have a questionnaire that nearly 200 people will need to complete, and the different scores they enter should be aggregated to calculate averages. Ideally, they could fill it out in Google Docs,…
-
Limitations when pushing data from MDB to RDB via Dataflow
All, Are we aware of any limitations when pushing data from an MDB cube to an RDBMS using a dataflow? Scenario Overview: We have an MDB cube composed of four entities - 3 General Entities + 1 Time Entity Entities Max Item Item Count Entity 1 100000 30141 Entity 2 1000 41 Entity 3 100 8 Month Infinity 204 The goal is to…
-
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…
-
level 200 - module 203 - Build a Screen to visualize the loaded actuals data
Hello, I am having a challenge with previewing data after completing the steps below My preview returns empty. with just product in the first row and total in the second. No other data is present. I suspect that I may have missed a step in the set up of the temp cube, but I struggling to find what it is based on the…
-
Unsynchronized Procedure names
Hi, I needed to adjust a procedure that is assigned to a field in a Dataview. However I could find it in the data model. Because it has been renamed at some point How can I synchronize the names to ensure someone can find it? Thanks, Maik
-
Why does the "Previous Year" time function still return current year data?
I would like to understand why, when I enable the Previous Year time function on the cube, the result still shows the current year's data. For example, I only have data for 2024. However, when I activate the function, the values returned are still from 2024 — instead of returning nothing (since 2023 data doesn't exist) or…