Best Of

PLEASE NOTE: This is a complete re-write as my original response to the second query as it was incorrect.

Hi Pierre,

Yes you can store the values in a cube as you calculate the values (remember that I am providing a recommended solution illustrated to show steps, not the one you will use in your solution).

You will need:

1. Entity 1 - [User Input] with 5 members; Input1, Input2...Input5
2. Cube 1 - [Data Entry] with [User Input] Entity and datatype: DATE
3. Cube 2 - [User Target Dates] with [User Input] Entity and datatype: DATE
4. Cube 3 - [User Target Values] with [User Input] Entity and datatype: DOUBLE
5. Button.
6. Procedure.

Setup:

DATAVIEW 1 - Data entry 

1. Create 1 dataview with Cube 1, entity on row axis, data entry enabled and SHOW ALL.
2. Enter a date into this object and save the data entry - you are seeding the cube as it will only be used to receive 1 entry and so you will not need the four other members to show.
3. Re-enter the dataview and disable SHOW ALL - You now have a seeded dataview displaying only 1 value.

BUTTON

1. Create a button and place it on screen - this will run the procedure which can only be created once the NEXEL calculations have been created and saved under a name.

DATAVIEW2 - This view will contain all 3 cubes, have data entry on 2 and process all the NEXEL calculations.  All actions are carried out by the procedure.

1. Create another dataview and configure as follows:
2. 
3. Enable Data Entry on blocks b and set formulas in to Deepest Entity Rule
4. Enable Data Entry on blocks c and set formulas in to Deepest Entity Rule
5. 
6. Enter Dataview [Fx] to create NEXEL calculations
7. Enter NEXEL Calculations into [User Target Dates - User Input 1,2...5].
8. Enter NEXEL Calculations into [User Target Values - User Input 2 & 5] - you can simply enter the address cell of the adjacent cell in place of the complete formula again.
9. Select SAVE TO LIBRARY - this allows you to run the NEXEL calculations from a procedure.  Savename = Save Values
10. Select to WRITE INPLACE - This causes the values to be written to the data entry enabled cubes when the procedure is run  

PROCEDURE

1. Create procedure [Transfer from Input cube to Target Cube] as follows:
2. 

Step:

1. Save all data entries - this is a failsafe that ensures new date entered is always saved fregardless of whether dataentry writeback is used by user.
2. Write the date to the first cube.
3. Run NEXEL calculations - This now computes, based on the user input date, all values and saves them to the cubes*
4. Refresh screen.

Application**

1. Return to screen
2. Select button settings
3. Configure action: [transfer from Input cube to Target Cube] 
4. Save capsule
5. Configure screen as required - below is an example where all dataviews have hidden scrollbars and toolbars to minimize needless screen responses - see image below

• IMAGE: Dataview Graphic Options
• 

Note I've included 2 additional dataviews to display the actual data saved.  when looking at the dataview with the NEXEL routine, it can be seen that figures are displayed.  However, as the cube datatype is DATE, these values are saved correctly - (big point to note here and one I forgot about too).  This is why the second cube is required for acting on those values as it is of datatype DOUBLE.

I hope that this is useful and you can see the versatility of BOARD dataentry and NEXEL for creating on-the-fly alorithm blocks used to manipulate date based calculations and expanding its use to create calculable values for further use.

It should also be noted that I have now tested this solution in Web and noted that this configuration does not produce a calendar tool for inputting dates on Web - this may produce issues to local date formatting and require you to determine the correct one to use.  I have not yet tested in 10.5.

Regards,

Paul Wyatt

Attachment:

1.   BOARD 10.1.4 hbmp & cpsx

---------------------------------------------------------------

* A NEXEL nuance is that it will calculate based on a value from a cube - the input date - but it will not write those results to a cube unless WRITE INPLACE is used and the routine saved so that it can be triggered in a procedure.

** It should be noted that this solution does not take into account multiple users.  A change in the input date and subsequent calculations will be seen by all users and can be changed by any one of them.  To prevent this, the application of @User security would be required in order that each user could run independent and isolated calculations on their own input dates.

Hi Marta,

I found that B11 handles masks in such a way that it was easier in my case to simply delete the original ones and re-create them.

That said, once the differences are understood, it is probable that the original ones will be usable with a little work.

1  MASK SCREEN ASSOCIATION.   Screens are associated to masks, not the other way round as in B10.  Image 1 below shows that I've associated three screens, Property Search, Property Details and Tenant Arrears, to the mask 01 Master Mask.

Image 1: Mask created and then screens associated to it.

2.   MENU TOOL BAR ISSUES.   The Menu tool does not 'play' well in B11 - I think it is a work-in-progress as I cannot find how it is configured - unlike in previous versions where it is a capsule config option.  As a result, I do not use this object now and, instead, place button like labels into the mask.  These labels have either 'goto screen' or procedures attached and I found this far more controllable than the menu object.  Image 2 below shows that a menu object simple presents all of the screens within the capsule.  Also, the font sizes and some of the other formatting options have no effect; a menu on a max resolution mask would be too small to read.

Image 2: B11 Mask with a menu object.  Note that the screens cannot be filtered and the font sizing has no effect.

3.   SCREEN SIZING CONTROL.   One of the best aspects of the mask is that it can be used to globally control the size of all screens associated to it as it overrides screen settings.  Once fully understood, screen sizing can be used to dynamically fit any display device from a HD 27" monitor to an iPad.  You should play with this to understand the best setup for you.  I have set my masks to 16:9 and fit to width.  However, 2560x1440 or any other resolution standard or custom can be set. 

I have placed my menu bar, built with labels, and icons to help me to visually identify the max width on screens.  Only then do I create my screens - much like we all do but I thought I'd outline the process.  Image 3 shows the screen sizing settings and the template I am currently using.

Image 3: MASK Screen template size settings override individual screen settings - very useful.

4.  Beta Feature -  Environment Background.   A fun setting is the environment background which can have a static image or a URL linked web image.  Image 4 illustrates a static capsule image and image 5 shows a live URL link feeding a jpg for the background.  If you control that jpg, you can dynamically switch it too - see, fun...(well it is to me as I don't get out much).

Image 4: Background with static image

Image 5: Background with a live URL feed to the BBC website jpg image.

Hope that this has helped in some way.

Regards,

Paul

Hi Mateo DE LOS RIOS

I can't find the reference at the moment but you might like to know that the functions of the Tilda database are being incorporated into a BOARD 11.x release.  This is good as it means that everybody now gets the benefits of centralised, advanced security control.  It is not so good if you've really gone to town with the Tilda and used it in everything you do as you will now have to re-do everything in an entirely new way which may, or may not, work as you are used to working (Guess which one my money is on?).

Personally, I welcome the incorporation into BOARD any of the original bolt-ons, like the Meta-tool (Worst kept BOARD secret super tool created by Jan Kaufmann), Log-analyser, Randomiser, Tilda, Transporter.  I also welcome the the replacement of BOARD features such as the MXC cubes. 

What is slightly irksome is the way these features and replacements are rolled out without adequate support to the few users that took the original tools and made them work, weaving them into their best practice to then have to learn an entirely new way and have to amend all existing models in order to be able to even use a new platform.

...Anyway , hope this helps

Hello Anastasia,

Many thanks for taking the time to respond and for explaining the technical issues currently being dealt with regarding the website.  Perhaps a BOARD notice to all community users would help in keeping BOARD developers aware of issues and cultivate support from them.

Thank you also for your comments regarding feedback. My aim in mentioning several points was to demonstrate that there are now a growing number of issues (a trend?) compounding to make the BOARD experience currently less enjoyable than it was.

As I'm sure you will know, each of the points I have outlined in my post has either been formally submitted as ideas or are current topics of discussion on the community website and I suspect the product team are already well aware of them.  On that note, I would welcome any opportunity to be involved in any follow up action.

Kind regards to you Anastasia,

Paul

Thanks Samuele Marchetto,

I like the nexel approach - I keep meaning to find reasons to use it but end up testing in it only to replace the solution with a dataflow or datareader process later. 

I was playing with the datareader date functions that you mentioned and that is another way and a method that will come in handy later and for another process I will be incorporating.

As a result of playing with your suggestions and so thinking about my needs more deeply, I was able to devise a method that uses a dataview to calculate the different date parts with algorithms.  As there is nothing, that I have found, on this matter and as the method is dynamic, I have submitted an Inspiration which outlines and discusses the method I chose to ensure it is more easily found by all.

However, for completeness and in summary, I created a dataview with several algorithms like this:

The cubes are populated with the numeric value of each of the dates so that calculations can be carried out.

Again, thanks for your response and so quickly too.

Using References, it is not possible to replace the member title with a custom one.  So long as I know how many columns I have 5, 10, [n] and that the number is fixed, I can create a custom entity/cube structure to sit above my dataview.  So, if I had 10 fixed columns, I would do this:

• Create an entity [Fake Title]
• Add the following members as follows

     1 - [blank]

     2 - [blank]

     3 - [blank]

     ...

     10 - [blank]

• Enter no of cilumns in MAX ITEM NR
• Create a cube [Fake Title cube]
• Add the entity [Fake title]
• Create an Admin Screen
• Create a dataview
• Add Cube [Fake Title cube]
• Add the only entity [Fake Title] to the column axis
• Select dataentry [x]
• You should now have a dataview with a single blank but yellow row.
• Type the custom titles into the yellow numbered columns - if no numbers, switch entity from default to code.
• Save the entries.
• Copy the dataview
• Return to your working screen and screen Hide the header
• Reduce the far left column to minimum = invisible on web
• Now set column width to that of target dataview and position on top - you may also need to set it to the back so as not to interfere with operation of source dataview.

hide the headers of the fake title dataview.

I think that's the correct sequence - was this any good to you?  Again, it is only useful for non-dynamic dataviews where the number of columns remains fixed and the data in them matches the fake title you have set.

Hi Bob, based on your question and diagram, you can achieve this through the block formatter as Helmut has said.  Below is the formatting, in red boxes, I set up to show a custom block, remembering to enable the custom block editor first.  Highlight the required level of cell Value, Total, Grand Total or all of them as I have.  Once highlighted, you can specify how it should look in options and Font boxes. 

Below is how I formatted a random dataview to meet your specifications (NB: I centred the % values to emphasise that the symbols before and after appear at the extreme end of the cell - this is not always desirable)

A good feature to use is the Copy and Paste which allows you to copy the completed format and paste it to the blocks that you want without having to format each one individually - useful for when you realise that you forgot to copy 'drag' the block with formatting, to create the subsequent blocks, at the beginning of the dataview creation - doh!

Was this what you're looking for?