-
CONNECTION or CUBE to .csv stored in FILE SHARE drive
Dear all, Maybe some of you have met the same issue: i would like to create a connection or a ROLAP cube to a ".csv" file stored in Shared Storage drive (GUI = microsoft azure) provided with full cloud version of Board (currently using 10.6). I could use the Shared Storage with:* Data Reader to load data in a cube (using…
-
Server Command - Batchfile not visible
Hello Togehter, i try to execute a batchfile with server command step. I placed a batchfile in folder /Board/Job, but it is not visible. Is there more configuration needed? Thanks for your Help!
-
Screen fit for various aspect ratios
Hi, Our masks are built with a custom aspect ratio that is close to 16:9 and we are using fit to width in the mask. Some users have ultra-wide monitors (21:9 aspect ratio) and for dashboards the screen renders completely differently and is no longer aligned. Chart labels are shifted over so that they are hidden from view,…
-
Scroll bars - change their colour, make them more defined/visible
Can you see that image above? That's a Board scroll bar. It is very difficult for users to see, it can be frustrating for them, moving their pointer over the screen hoping to find where the scroll bar is. Is there a way to make it more visible? Can the colour be changed? ------------------------------ Michael Gerrard UNHCR…
-
Unbalanced Hierarchy in formatted report
Hi experts, I would like to know how have you all used unbalanced hierarchy in the reports? I have a P&L structure which I define as an unbalanced hierarchy in an entity. This works fine and shows the correct roll-up. the problem arises when I use this unbalanced hierarchy in a report * In the report, the parents should be…
-
Excel and Web log in at same time
Hello, It would be very helpful if we could be logged into Board Excel and Web at the same time. There are many times that I am monitoring users submitting data on the Web and I'm in Excel refreshing files. This causes me to get logged out of the web and go back in, click on the capsule, then screen, then select the…
-
Get cube values for first and last element of selection
Hi, I need to show in a data view a column with the values related to the first element of a selection. I also need a column with the value for the last element. For example, the selection is for the months from January to June. I want the values for January. I used the ANALYTICAL FUNCTIONS > First Value, setting the From…
-
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.…