how to create crosstabs using drag and drop functionality?

[udung]

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

[BigChris]

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

[udung]

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

[BigChris]

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.

[MFGF]

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.

[udung]

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

[MFGF]

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.

[BigChris]

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

[udung]

Hi Big Chris,

its okay chris


thanks big  ;)

[udung]

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

[MFGF]

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.

[MFGF]

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.

[BigChris]

That's interesting...might be an option for us to roll out Cognos to a wider audience, especially if the licensing is cheaper.

[udung]

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

[MFGF]

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.

[udung]

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