hi all,
how to create crosstabs using drag and drop functionality? (like drag and drop in OLAP report)
please give document guide or link
thank u
1. Create a blank report
2. Drag and drop a crosstab into the report
3. Drag and drop a dimension / field into the rows
4. Drag and drop a dimension / field into the columns
5. Drag and drop a measure into the measures area
6. Run the report
Hi Big Chris,
thank u for response
i need create complex crosstab, like to drag and drop a dimension or measure dinamically (like drag and drop in OLAP report)
can u guide me to do it?
thank u
I don't think what you're asking for is possible in report studio (I'm sure someone else will update this if it is possible). I'd suggest creating the report in Analysis Studio so that the user can then dynamically change the fields in the report.
I'd suggest Cognos Workspace Advanced rather than Analysis Studio. This is where IBM seem to be investing their development efforts.
Just sticking my oar in! ;)
MF.
Hi Big Chris and MFGF,
thank u for response
just info, i use Rational Insight (Cognos bundled). But in Rational Insight, i not found Analysis Studio and Cognos Workspaces Advanced.
if anyone know to create complex crosstab in report studio, please give me advise to do it
thank u
Quote from: udung on 27 Feb 2014 04:02:22 AM
Hi Big Chris and MFGF,
thank u for response
just info, i use Rational Insight (Cognos bundled). But in Rational Insight, i not found Analysis Studio and Cognos Workspaces Advanced.
if anyone know to create complex crosstab in report studio, please give me advise to do it
thank u
Do you see Business Insight Advanced? This was the prior name of Cognos Workspace Advanced.
MF.
Hi - I've done a bit of googling and it looks like Rational Insight is a different product to Cognos BI. There are bound to be similarities, but it's not a product I've used I'm afraid. There might be another forum section in Cognoise for it...but again I wouldn't know. Others on here might be able to help, but I'd try posting in another forum if I was you.
Sorry I couldn't be more help.
C
Hi Big Chris,
its okay chris
thanks big ;)
Hi MFGF,
ya i see Business Insight Advanced
okay i will try to use it
btw can u give me the document guide or link to create complex crosstab?
thank u
Quote from: udung on 27 Feb 2014 04:56:19 AM
Hi MFGF,
ya i see Business Insight Advanced
okay i will try to use it
btw can u give me the document guide or link to create complex crosstab?
thank u
That's a bit like saying "Can you tell me how to write a complex document". It could mean a vast number of things. What is it you are trying to do?
MF.
Quote from: BigChris on 27 Feb 2014 04:27:40 AM
Hi - I've done a bit of googling and it looks like Rational Insight is a different product to Cognos BI. There are bound to be similarities, but it's not a product I've used I'm afraid. There might be another forum section in Cognoise for it...but again I wouldn't know. Others on here might be able to help, but I'd try posting in another forum if I was you.
Sorry I couldn't be more help.
C
As far as I'm aware it's Cognos 10.1 BI server with restricted licenses. It's the exact same technology I think.
MF.
That's interesting...might be an option for us to roll out Cognos to a wider audience, especially if the licensing is cheaper.
Quote from: MFGF on 27 Feb 2014 05:32:12 AM
That's a bit like saying "Can you tell me how to write a complex document". It could mean a vast number of things. What is it you are trying to do?
MF.
Hi MFGF,
i mean are u have document guide to create crosstab with drag and drop functionality like in OLAP report?
thank u
Quote from: udung on 28 Feb 2014 12:39:05 AM
Hi MFGF,
i mean are u have document guide to create crosstab with drag and drop functionality like in OLAP report?
thank u
Hi,
Business Insight Advanced is designed to be an end-user tool for people with little or no technical experience. The whole idea is that creating things is a simple drag-and-drop experience.
Choose the option to create a new report
Select "Crosstab" from the list of templates
Drag in the desired data items from the contents pane on the right
Simple :)
MF.
Quote from: MFGF on 28 Feb 2014 11:03:58 AM
Hi,
Business Insight Advanced is designed to be an end-user tool for people with little or no technical experience. The whole idea is that creating things is a simple drag-and-drop experience.
Choose the option to create a new report
Select "Crosstab" from the list of templates
Drag in the desired data items from the contents pane on the right
Simple :)
MF.
Hi MF,
okay i will try it
thank u