-
Month entity without year
Hi, I'm using a dataview for sales analysis. On the rows I have the year entity. I need to put the month on the columns, to get 12 columns of data (1 for each month). If I use the Month entity I get one column for each month of each year. My Year entity has 5 years, so I get 60 columns. Can the month name be extracted from…
-
[IFRS16 APP BLA] Cube Corruption
Hi, We recently had a problem with a procedure because some cubes were corrupted, are there any best practices to follow for to prevent this problem in the futute? The version of the BLA database is 12.1. Thank you in advance for any response, Francesco. ------------------------------ Francesco Tufaro Consultant TECHEDGE…
-
Board 10.6 IIS Kerberos settings login
Hello, we have searched in the KB library and in some post, but we can't find the correct settings to setup the Windows authentication to Board Web via Web Browser . Actually we have setup Board 10.6 Server with the IIS active service and Board client also works great with Windows and Board defined users. Unfortunately…
-
Best practice to add a dimension to existing cubes (Board 12)
Hi, I need to add a new dimension to some existing cubes. These cubes have a dimension related to delivery customers and the new dimension is relative to invoiced customers. Is there a best practice for this scenario? I followed this steps: - Entities creation (Invoiced customer, city, category, ...). - Relationship…
-
pattern based allocation - how it works?
Hello all, I'm searching for a description (Doku, Video...) for the function "pattern based allocation". How must it be configured? I hope someone can give me some help. Thanks in advanced. ------------------------------ Stefan Batalia Board Administrator Arntz Optibelt Group Germany ------------------------------
-
Screen fit, Fit to single page changed after restart
Hello all, when I change the settings "Screen fit/Fit to single page" this settings will not be stored. When I reopen the same screen I must do the same again. Is there a possibility to save this setting? ------------------------------ Stefan Batalia Board Administrator Optibelt GmbH Germany ------------------------------
-
Services restart not working consistently
Hi, I restart the services each night via a batch file. According to Task Scheduler, the task is completed every night. Yet, half the time, databases are loaded into memory that have not been accessed since the previous day - indicating that the services did not restart. The main issue is high memory usage before the…
-
Import txt. into multiple columns
Hi, How can i import data from a txt. file into Board? The import file contains 20 columns per row with data. These columns are accounts. In board, i have set these accounts up as an entity with 20 members (account a,b,c..etc.) in it. In the data reader i cannot select each account member (a,b,c..etc.) individually to…
-
Nexel - Calculation
Hi, I'm working with Nexel and have to data views in the screen. The last one I'm using Nexel to hget a value from the first data view by having this formula =["Nettkapital;@f;*;*;Range.Vertical] and this works. The main goal is to multiply the "Nettkapital" (Grid Capital) with 1.01. This do noe work in my data view. It…
-
sum of hours
Hello all. I need your help trying to see how I can model a specific request. I need to create a dataview storing hours (see pictures here below) By row I have the agent, by column the day of the week (m,t,w,t,f,s,s), data are the number of HH:MM the agent worked that day. At a certain point I need to sum all the hours in…
-
Sorting data view with multiple entites
Hello, I have a dataview with two entities by row: - Business - - P&L Line How can I apply a custom sort to the Business entity? It only sorts by Code or by Description, and the Filter -> Sort in data view options only applies to P&L line. ------------------------------ Mark Developer Australia…
-
Profit und Loss Statement: Special Structure of columns
Hallo everybody! I would like to create an P&L Statement with the following structure: Column 1 to 6: Information to actual month Column 7: row structure of the P&L Statement Column 8 to 13: Information to the cumulated value It should be also possible to expand or collapse the row structure. An Example is shown at the…
-
Circle alerts in 10.7 web
It seems that using circle alerts no longer works on 10.7 web if the cell that should contain the alert is 0 and Hide Zeros is enabled (default setting). There is no way to show the circular alert unless you show zeros. Is anyone else having this issue? ------------------------------ Jason Febo Architect metrix-CS United…
-
Get error for administrator login after update to 11.3
Hi I am get a error for a single user (administrator with windows login). ------------------------------ Charanjit Rai VP Live Technologies !nc. Canada ------------------------------
-
Drillable Headcount Report - don't show grand total or column total
Hi, Apologies if this has been asked before, i'm struggling to find an answer in previous questions. I would like to build a drillable headcount report by week, showing both headcount and FTE KPIs by department. I would like to show subtotals as you drill down the types of headcount and into the department, so i have…
-
Menu not working in version 10.6.0.3?
Hi, I have applied a "Menu" possibility in a screen for different users with different access to folders and capsules. The target is "Capsules" and position is "Root". This works for the admin user, but not for others (the Power/LitePlus/Lite users), they get the errormessage: "No items to show". Is this a bug in this…
-
Dynamic Time Selections
What is the most efficient way to make a selection based on a custom time range? For example, I want to see data from the last 90 days, or the last 6 periods. Thanks! ------------------------------ Mallory Lindsey Business Reporting Analyst Pepsi Bottling Ventures United States ------------------------------
-
SQL load, error log
Hello All I get rejected items while loading data from a SQL table. I have ticked the log file option but I cannot see where the log file is saved (Using BOARD 11 - Cloud) I looked at the logs on the board cloud administration portal but cannot see anything under SQL logs. When I load from flat file it generates the log…
-
NEXEL on Web
We recently upgraded to 10.6 and I had a dataview with a lot of cell based deep entity nexel formulas, pulling from other columns (blocks). I accidentally deleted an entity member. On re-adding the member I can not find how to re-add the nexel formulas associated with it. This was very easy in the client version. How do…
-
How to add two dimensions by column without displaying row totalss
Hello! I have a cube with 2 dimensions : day, product. (relationship: day(N)-> month(1), product(N)->plant(1)) for example, I want to populate plant and month by column in my data view. Usually, if I populate 2 dimensions by column, there will be an error. -> "an error occurred" as picture 1. I could get a result only if I…
-
Dynamic Column Layout
Hi Can we have a dynamic column Layout using Pager ? (The columns of the Layout should change depending on the Pager entity selected) Thanks, Vamsi. ------------------------------ Vamsi Krishna Associate Software Engineer SIMBUS TECHNOLOGIES PRIVATE LIMITED India ------------------------------
-
Pie Chart without Axis Configuration
Hi together, just a simple question this morning: Ist there any way to configure a pie chart comparing two measures (blocks) without having a dimension set into the axis tab? I just want to compare measure a with measure b: Thank you and best regards!
-
Horizontal/Vertical Style not working In Menu setup for folders on 10.6
Hello, I am using Board 10.6 Web Designer, I created a folder with some screens, and I would like to use Horizontal/Vertical Style for the folder I created In a screen or mask, but it shows nothing, it is just blank, all the other styles, such as Standard or Accordion are working well. Please see the attached screenshot.…
-
Selector on "Pop-up window" type does not display entity member on Board 10.6 Web
Hello, I tried to use selector on Board 10.6 Web, but it does not work on "Pop-up Window" type, it just does not show the member you selected on the selector. I know it is the same in Board Client, but is there any way to let it show the member if the single member selected? Please see the attached screenshot. Thanks.…
-
How to Adjust Position (Fine Tuning with Arrow Keys) of Object in a screen in Board 10.6 Web Versio
Hello everyone, We just move Board to 10.6 Web Version. In the Board Client, we can adjust position (Fine Tuning with Arrow Keys) of Object in a screen, but it seems we cannot do any fine tuning on the web anymore, we only can use mouse to move the object, which is very hard to adjust the position of Objects with very…
-
Board 10.6 Web Service Error
Hi all, I installed Board 10.6 on a brand new machine (MS Server 2012), and configure the Web service as followed the instruction in https://community.board.com/viewdocument/how-to-setup-microsoft-iis-with-boa?CommunityKey=fce3410b-1520-47cb-bd8c-6cdd5a5b5ad9&tab=librarydocuments I can access Board via Web on the localhost…
-
BOARD Chart Object
Hi, we want to implement a central dashboard (SIOP Graph) for our logisitics guys in the plants. The central chart is a combination of a few kpis, which build the different bars. Another aspects are the vertical lines, which show thresholds. My first question is: is it possible to create a chart like the one shown…
-
Dynamic Selection on Screen
Hello everyone, I have a query regarding multiple dynamic selection on one Screen: I have several charts, KPIs and data sets on one screen. Some of those should have a filter on the currenty Year, some current month and some current day. I know that the possibility exists to build cubes with such selection. However it…
-
Dynamic Selection on 2 entities
I am trying to create a dynamic selection based upon the intersection of two non-related entities (assume salesperson and customer) such that when a salesperson is selected from a pager the dynamic selection will show only those customers for the salesperson selected. I built a cube based on these two entities as follows:…
-
Overriding Board total for specific Dataview items
This is probably a stupid question, so I apologize in advance. I am building a Dataview for an income statement where months are shown as columns with an annual total. Some of the members of the income statement represent headcount data where the "total" for the year should be the last month value, while of course the…