Data Operators & Combining Data Streams

Hi,

Two thoughts: 

1. would it work, to maintain a distinct attribute for each different type and then to adapt the query?
2. could you query for: =QUERY_ITEM_DEF_SYMBOL(Cell) and then adapt the dashboard query?

Best,

Veronika

Hi Veronika, 

A small disclaimer: I have very limited programming / query knowledge. I am basically a BPM expert, but using systems to extract data and convert them into meaningful data is very new to me. I have created 2 dashboards already through learning and trial & error, but I feel this complicated scenario is a challenge.

Giving distinct attribute value may be quite useful, its a good tip. The only downside is I will have to change each and every object in the org chart, which I am trying to avoid. If nothing else works, this might work. However, the same I am able to do using 'symbol' as a filter as well. The 'symbol' different just doesn't translate as a separate column in the data feed. That's my challenge. Even in the query as I put these 4 symbol filters, it shows up as a single column. And I don't see any options for controlling how columns look in the query table, which I feel should be quite simple. 

I will also try the simple command you have provided as a 2nd option.  

As far as 1 is concerned: 

1. Which ARIS installation do you use? Architect? Connect?
2. Which version are you on?

so the option 2 definitely helped thanks! Now I do have a vertical list that clearly identifies the symbol. The weird thing is I am unable to use COUNTIF formulas in the query to give me count by symbol. Can I do that somehow in the dashboard / data feed? I am trying but without sucess at the moment. 

what do you want to do with that information? I am asking because the query does not allow for a count if... but maybe there is a different approach?

Thanks very much. Your suggestion gave me a great inspiration, and I was able to identify the symbols and relay them on the dashboard! 

I basically wanted to show live counter of the number of offfices, depts, section etc. 

 Veronika you are faster than light 😎

Sorry I think I missed this comment - for queries, I use Architect / Designer, for dashboards I use Connect (as I think that's the only option) 

Version: 10.0.25.0

By the way, I am not sure what others think, I do feel that the classic data feed and dashboards were much more easier and intuitive to use, with a simpler user experience. 

I get the new version looks cooler, but I am really struggling with its ease of use. 

haha, as if^^ but thanks anyways :D

I feel the latest version is much more intuitive and more user friendly. Also, they offer more functionalities :)

Thanks a lot for your help, it was very useful! Much appreciated. 

That’s true 

The new are used in data feeds exactly as the old 

In dashboards there was the simplification of filtering so that you have not to wire every widget but simply push the filter criteria to the context.

With the current version SR28 we have started to use the Repository search as data source to minimize need of queries and architect .

We can connect with mining, we have a better integration within the tool (ARIS repository , GRc, more widgets , smooth layout …. )

We have converted all our dashboards to the new ones and we do not recommend the useage of the old dashboard editor anymore.

Hamza may you share me your use case (model, query dashboard) and your struggles so that I can understand it a little more and I write something about it via blog ?

Best

Monika 

Hi Monika, yes I will describe it here. Let me know if you need any more specific details. 

My use case was to get a simple representation of the count of different types of organizational units in my group. These units are already reflected on the Org Chart model. The challenge I was facing was that they were all represented by the same object types, however the symbols were different. 

So although I was able to run a query filtered for symbols, I wasn't able to run a command in the query or data feed that could distinguish them by symbols and count them separately. I was basically trying to find a way through the data feed & dashboard editor. I don't yet have enough knowledge about the operators and how they transform data, as I thought I could aggregate or use the filter option. Then I tried to even create 4 different queries for each symbol type, so that in the datafeed I could somehow bring them together using the 'combine' option, but even that didn't work - the 4 data streams I was unable to combine. I tried 2 at a time, and even in that I couldn't find an option to segregate by symbol.  

Veronika's suggestion however worked great - I need to add an additional column with a command for identifying the symbol type. Once I did that, the datafeeds were easy to reflect this column and the dashboards were able to show them separately.