If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Can you join queries in Dashboards?

Started by pacificbeavs, 28 May 2019 03:25:39 PM

Previous topic - Next topic

pacificbeavs

I'm currently using 11.1, and I've created many standard and active reports, however I'm just starting to dabble with dashboards.  Many times I need to join together multiple queries, however I don't see that as being an option with dashboards. For that matter, I don't even see where the query is generated.

Am I missing something, or should I stick with active reports for that type of reporting?  On a side note I read somewhere that active reports would be phased out, which is one reason (along with lack of maps for active reports) that I'm messing around with dashboards.

Thanks!

bus_pass_man

You can't join queries in the dashboard.  You might want to investigate data modules for that sort of thing, depending on what you're trying to do.

pacificbeavs

Quote from: bus_pass_man on 28 May 2019 05:49:57 PM
You can't join queries in the dashboard.  You might want to investigate data modules for that sort of thing, depending on what you're trying to do.

Okay thanks; I've created a couple of data modules previously, so I can mess around with them further.

bus_pass_man

What tool you choose should be determined by your business need.  You shouldn't need bash your head against a wall just because someone has decreed you do something.

You have noticed that there's no UI for cascading queries such which exists in report studio.   This should give you some idea about how difficult it would be to apply your report studio approach to the dashboard.

This is especially the case as I'm assuming you'll be trying to use the queries to do things like prompt pages etc.  You will soon find that sophisticated prompts have problems in the dashboard.

That said I am saddened that people insist on doing stuff in report studio which they should do in a modeling tool.  I'm not just thinking of those who insist on writing SQL queries and generate static reports.   I've always thought that building an application -- in a package, a cube, a module, or whatever -- where ordinary business people could explore and generate queries where they are liberated from the tyranny of dependence on report writers, the IT crowd, and consultants is a far more desirable goal.   

I am saddened that sometimes they can only do it there.

The probability is that you need to stick to report studio.

pacificbeavs

It's definitely a possibility to push what I'm doing upstream and have a developer build it in the ETL/framework, however many times there's instances that I need to build something that isn't reflected in the model yet.  Thanks for the input, at least now I know the limitations of dashboards and can adjust as needed.