Best Of

Hi Tanja Kärcher,

try this:

if your Layout has a Block "a" (Cube) multiply a*1.1 or maybe 1.2 in a second block "b". Make sure that both blocks will be shown in the chart (Options tab).

Then use the legend to "hide" block b by giving it the color "transparent". Check "Show Labels" and set the background color of the labels to trasnparent to. 

In both blocks you have to use the combine mode "None" (you can do this setting in the legend, too). 

Then go to the "Settings" of the chart to the tab "Format". Under "Object to format" you choose "Markers" and give them the text color of your choice.

As example you can see the output attached.

Hope this will help you.

Regards, Fabian

Hi Adam,

you could also keep track of your idea.

Include your data entry cube into the layout of the data view three times.

• One time with refer to 3 month avg,
• one time with refer to 6 month avg
• and another time with refer to 9 month avg.

The data entry cube will be virtually ripped up and shows "0" or "1" (depending on your entry in the data entry layout) in every single row.

Now you have to multiply your data cubes with your filter cubes (data entry cubes) in a column algorithm. I.e. 3 month avg filter * 3 month avg data. Depending on your data entry on the filter cube, the column will be shown or not. Do this for any avg. Important is to disable "show all" in your axis configuartion on columns.

Regards

FabFro

Hi Tanja Kärcher,

if you set fixed ranges for primary and secondary axis you will get the "0" at the same level.

For example I chose your suggested ranges like x axis from -1 million to +1 million and y axis from -100 to +100.

The result looks like this:

Let me know if you need further assistance.

Cheers,

Johannes

Hi Hannes Keller,

I suggest to use Bettina Clausen solution if you got cut markers. 

Just for the future: You can adjust the lines/stripes in the "Axes Configuration" (at the bottom):

Kind regards

Johannes

Hi Dirk,

just an addition to my first post: You can also press F5 in WinClient to reset the master selection.

You can't reset the master selection in WinClient within a capsule procedure, that's right.

And now a short instruction how you can avoid your master selection problem:

1. Deactivate the master layout in your dataview

2. Create a capsule procedure with two steps:

            a) Apply selection to screen

            b) Refresh Screen

3. Right click on drill down in your table in developer mode. In the opening window click on tab "procedure" and add your capsule procedure. It should look like this:

Your drill down now should look like this:

4. Create a second capsule procedure with the following steps:

               a) Reset selection on entity (your entity) respectively Reset selection on tree (tree containing your entity)

               b) Apply selection to screen

               c) Refresh Screen

This would be the procedure you can integrate in your button you mentioned before.

5. If you dont like to get only one line in your first dataview after you selected the specific row, you have to options:

               a) Use the layout selection tab in your dataview and select all items of your entity

               b) Create a new entity and create an aggregated relationship to your entity.

                   The new entity should contain only one item: "ALL"

                   Normalize your tree to set all relationships of each item of your entity to ALL.

Let me know if it works and if you need further assistance.

Cheers

Johannes

Hi Daniele Di Lorenzo,

you can set the encoding of your csv files directly in the datareader settings:

Try to find the encoding of your files and the characters should then display correctly (however, the prerequisite for this is that the characters are displayed correctly in your source file).

Cheers

Johannes

Hello Stefan Batalia,

you are also able to use "@Selection_Ex" in a label. Here you can define display, range, limit and so on.

You can find more information about @Selection_Ex here: layout_enhancements 

In your case:

@Selection_Ex(Entity="Sales Organization",Limit="1",Display="Desc")

(where Entity is the name of your entity, limit is the number of elements to show and Display means how to show your selected element, e.g. "Desc" for description.

Hope it helps.

Regards

Johannes

Hello Federica Paladin,

just use the description of Björn Reuber to create a batch file and save this on the server, e.g. at Board\Jobs.

Create a new task in the windows task scheduler with your desired settings (time, iteration and so on). Set the task to trigger the batch file.

That's it.

BR

Johannes