HiAdvice needed on dataflow procedure

Unknown

Hi Boardville,

 

thanks again for your help, I enjoy the community and make progress in getting more knowhow

Still I got a question.

 

I have the following task:

 

In my database is a cube which shows 'Sucessful Logins by User', which looks like this.

Layout Select based on "Login Action"

 

From this cube I want to exclude the Admin and Controller entries, therefore I created an additional cube based on the same dimensions, so that the database looks like this.

Layou Select based on "Login Action"

Layout Filter on a Cube which filters out the Admin and Controlling Users.

 

Now the challenge:

 

Instead of showing the tables, I want to present this in a chart, but instead of showing the results by user it should show them as a "Total" number, which should be like that:

As far as I know, I can't use the same cube in Board for the graph because the one is based on multiple dimensions. 

My idea was to create a new cube based on the dimensions: User, Month. Add a new User called "Total" in the entity and then I wanted to use a procedure to copy-pased the total numbers of the cube 'Succesful Logins by User (excl Controlling, Admin', to the new cube, on the user entity 'Total'. However I am stuck at this, don't know how to do that, or if this is even possible.

 

Does someone has a solution in mind, hope my explanation is clear

 

Thanks

 

Mathias

Björn Reuber

Hi,

 

this should already work. Just using your Cube Sucessful Logins by User.

I think easiest way would be to create a new screen, Select all users you need (or exclude admin / controlling HINT Maybe a parent Entity could make sense here).

then use a Chart only containing Sucessful Logins by User and Day in by Row. Now you should get the desired result

 

regards

Björn

Unknown

Hi Björn,

 

thanks for your reply.

My problem is that the chart should only contain one line (total) and not a line per user.

So when I put the User and Day (Month) in the row this is not possible.

I somehow need to transfer the total numbers by user to a cube which stores the totals on the entity Month.

This is what I do at the moment, manually, if possible I would like to create a procedure to automate that.

 

Regards

 

Mathias

Dietmar Jeschkeit

Hi Mathias,

 

it is like Björn said. You don´t need another cube or procedure, see pictures. For excluding members use the selector for the screen.

Unknown

Hi,

 

thanks for your help.

 

I guess my case is a little bit special. I understand how your solution works, but using the Screen Filter is not an option for me, as I am using multiple charts on the same screen and some of them should show all users, also including Controlling and Admin.

Therefore I tried to use a Filter Cube, all Admin & Controlling Roles get a "1" in this cube and then are excluded via Layout Filter. I have a data view in which this works.

 

As you can easily see this dataview uses to Axes 'User' and 'Month' so I can't use this layout to get the graph, only using 'Month', I am looking for. Therefore I was looking for a procedure which writes the 'Total Successfull Logins' per month on a cube which only has Month as an Axes. 

 

At the moment I am filling this cube manually, using the totals per month/user from the above mentioned data view. 

 

Regards

 

Mathias

Previous Member

Hi Mathias Flintrop,

 

the tab "Select" of the layout is there to filter only your dataview/chart in addition to the screen filter. See Layout Select for more details. As suggested by Dietmar Jeschkeit and Björn Reuber just filter/select the data. Just do it in the dataview/chart additionally to the screen.

 

 

On another aspect you mentioned in your question:

As far as I know, I can't use the same cube in Board for the graph because the one is based on multiple dimensions. 

This is not true. Board is able to aggregate on cube on any of the dimensions that are selected for the cube versioning. See Creating an InfoCube for more insight. Have at look at this:

Here you see that some versions do not use all of the dimensions. In those cases the values are pre-computed. In case there isn't a pre-computed result, Board will aggregate the data on the fly.

 

 

BR, Ray

Dietmar Jeschkeit

Hi Mathias,

 

for a screen with objects with different selections you can use the "inner" select of the layout (selection tab in layout). 

I would prefer to make an Entity called for e.g. "Usergroups" and make this a parent of the Entity "User". In Usergroups you have the elements User, Admin, Controller. Now set the ralationship from any User (User 1, User 2, etc.) to User, for any Controller to Controller and from Admin to Admin.

Now you can use this new Entity for the inner select of any layout. If you have more data unfiltered on the screen, set the inner select on the Layouts where you don´t want to see the admin and Controller.

 

Result (same screen of course):

No Need for another cube or procedure.