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

Active Reports Prompts

Started by cognos05, 15 Aug 2014 03:15:40 PM

Previous topic - Next topic

cognos05

Hi All,

I have a report created in report studio,

This report has 4 prompts - 2 prompts each cascaded from different dimension.
These prompts are used for filtering my crosstab and are not present in my crosstab.

I want to develop this report as Active report to be used in ipad.

Can I still use the same value prompt here or should I use a different control . How do I achieve this.

Any heads up is appreciated.

Thanks,
Nithya

MFGF

Quote from: nithya1224 on 15 Aug 2014 03:15:40 PM
Hi All,

I have a report created in report studio,

This report has 4 prompts - 2 prompts each cascaded from different dimension.
These prompts are used for filtering my crosstab and are not present in my crosstab.

I want to develop this report as Active report to be used in ipad.

Can I still use the same value prompt here or should I use a different control . How do I achieve this.

Any heads up is appreciated.

Thanks,
Nithya

Hi,

No - you wouldn't use prompts. You would use active report controls to make your selections and probably a data deck these would select.

Take a look at the Active Reports Cookbook to get an idea of how these things work, then post back with any specific questions:

http://www.ibm.com/developerworks/data/library/cognos/reporting/active_report/page593.html

Cheers!

MF.
Meep!

cognos05

Hi MFGF,

I used data drop down list for my prompts and was able to achieve cascading prompts using it. I had 4 datadrop down list and created four active report variables and controlled them.

Now the issue is my crosstab below this data drop down doesnt contain these four values , they should just filter on this.

So when  I try to create a connection between these drop down list and crosstab I could nt find the matching dataitems.

FIltering on crosstab will not work..

Please let me know on how to achieve this.

Thanks,
Nithya

MFGF

Quote from: nithya1224 on 21 Aug 2014 08:39:10 AM
Hi MFGF,

I used data drop down list for my prompts and was able to achieve cascading prompts using it. I had 4 datadrop down list and created four active report variables and controlled them.

Now the issue is my crosstab below this data drop down doesnt contain these four values , they should just filter on this.

So when  I try to create a connection between these drop down list and crosstab I could nt find the matching dataitems.

FIltering on crosstab will not work..

Please let me know on how to achieve this.

Thanks,
Nithya

Hi,

Two options:

1. Add the extra items to the crosstab, then hide them, and filter the crosstab based on your existing four active report variables
or
2. Use a data deck, containing these four values. Put the crosstab in the data deck. Add the values to the query of the crosstab. Create a master/detail link between the crosstab and the data deck based on these four values. Drive (select) the data deck from your existing four active report variables.

Cheers!

MF.
Meep!

cognos05

I added the items to cross tab and ran the report , the report keeps on loading. Is this could be due to large data..How can I check wats going on.

This happens only after I addd those columns to crosstab.

Thanks,
Nithya

MFGF

Quote from: nithya1224 on 21 Aug 2014 09:21:37 AM
I added the items to cross tab and ran the report , the report keeps on loading. Is this could be due to large data..How can I check wats going on.

This happens only after I addd those columns to crosstab.

Thanks,
Nithya

Put the same items into a crosstab in a "normal" report and run it. How many pages does it span?

MF.
Meep!

cognos05

There are totally 42 pages . I think this is delaying and loading the active reports page.
I thought I will run the report and burst it for each distributors which would be around 40.

1)  I have  Sub Region and reps in my prompts cascaded
2) I have product and sub product cascaded in my prompts

Normal Report Studio Report:
My cross tab has a customer accounts which is the next level of reps and the expression for this data item is
topCount ([Sales].[Customers BillTo].[Customers BillTo].[BillTo Customers],25,[Measure]).

SO when I run my report my accounts in the cross tab changes for each product type chosen.

Active Reports:

Have 4 drop down list.
Included All four prompts in cross tab as well.

Now my cross tab will have the items nested in rows.
SubRegions -> Reps-> Accounts
And Columns will have product ,subproduct nested and then measure.
here the expression for customer accounts is still the same.

But the accounts is not changing when I change my product or product subtypes.

Its actually filtering the values on crosstab but not the actual accounts.

Any help is appreciated.

Thanks,
Nithya

MFGF

Quote from: nithya1224 on 21 Aug 2014 10:29:58 AM
There are totally 42 pages . I think this is delaying and loading the active reports page.
I thought I will run the report and burst it for each distributors which would be around 40.

1)  I have  Sub Region and reps in my prompts cascaded
2) I have product and sub product cascaded in my prompts

Normal Report Studio Report:
My cross tab has a customer accounts which is the next level of reps and the expression for this data item is
topCount ([Sales].[Customers BillTo].[Customers BillTo].[BillTo Customers],25,[Measure]).

SO when I run my report my accounts in the cross tab changes for each product type chosen.

Active Reports:

Have 4 drop down list.
Included All four prompts in cross tab as well.

Now my cross tab will have the items nested in rows.
SubRegions -> Reps-> Accounts
And Columns will have product ,subproduct nested and then measure.
here the expression for customer accounts is still the same.

But the accounts is not changing when I change my product or product subtypes.

Its actually filtering the values on crosstab but not the actual accounts.

Any help is appreciated.

Thanks,
Nithya

I think you need to go for Option 2. Use a data deck as detailed above :)

MF.
Meep!

cognos05

Even the second approach is not working.

My Data item in my report has an expression TopCount(Accounts,10,[Measure]). But this value doesnt seem to properly work when connected with data deck and linked by masterdetail.

And always my prompts first value is being filtered by default, which is causing the issue.

When I choose a Sub Region , automatically the first value in rep (cascading prompt) is filtered but the prompt still shows choose a rep.
Any idea on why is the first value of prompts being filtered without that being selected.

Thanks,
Nithya

MFGF

Quote from: nithya1224 on 22 Aug 2014 07:30:30 AM
Even the second approach is not working.

My Data item in my report has an expression TopCount(Accounts,10,[Measure]). But this value doesnt seem to properly work when connected with data deck and linked by masterdetail.

And always my prompts first value is being filtered by default, which is causing the issue.

When I choose a Sub Region , automatically the first value in rep (cascading prompt) is filtered but the prompt still shows choose a rep.
Any idea on why is the first value of prompts being filtered without that being selected.

Thanks,
Nithya

Hi,

It's not clear what your issue is here. What does "this value doesnt seem to properly work" mean? Is the context of the topCount() the same in the data deck as in the crosstab?

You are referring to prompts here too, but you can't use prompts in an Active Report MHT. Are you referring to your active report controls? If you have set up cone control to drive another, how did you do this? You haven't given us enough detail to be able to help...

Cheers!

MF.
Meep!

cognos05

The issue is when used with crosstab my datadropdownlist's first vale is filtered by default eventhough I dont select any.This inturn selects my first prompt value in my cascaded prompt.
These first values are not shown in the cascaded prompt but still data is filtered on it.

Have anyone faced similar issue.

Thanks,
Nithya

MFGF

Quote from: nithya1224 on 22 Aug 2014 08:13:50 AM
The issue is when used with crosstab my datadropdownlist's first vale is filtered by default eventhough I dont select any.This inturn selects my first prompt value in my cascaded prompt.
These first values are not shown in the cascaded prompt but still data is filtered on it.

Have anyone faced similar issue.

Thanks,
Nithya

It sounds like you defined a default value for your first active report variable? Have you checked this?

MF.
Meep!

cognos05

Yes I did removed this and checked also.But still my prompt will say choose subregion ,but the cross tab is filtered on with first value from prompt.
It works fine with the list.

I removed default value.

Thanks,
Nithya




MFGF

Quote from: nithya1224 on 22 Aug 2014 09:04:59 AM
Yes I did removed this and checked also.But still my prompt will say choose subregion ,but the cross tab is filtered on with first value from prompt.
It works fine with the list.

I removed default value.

Thanks,
Nithya

Hi,

You shouldn't have prompts in an Active Report - only active controls.

If your crosstab is on a data deck, and linked via a master/detail to this, you will be seeing the first card in the deck, presumably for the first variable value? The way to get past this is to select the data deck, enable a default card in properties, then drag a crosstab onto this and have no link.

Cheers!

MF.
Meep!

cognos05

You mean no masterdetail relationship between crosstab and data deck . I dint understand the steps.
1) Create a data deck and add four active control values (mapped dataitem) in data deck
2) Set the default card to Yes
3) Drag a Cross tab and should I add a master detail link between data deck and crosstab
You had mentioned no link, then how will it be connected with data deck.
Thanks,
Nithya


MFGF

Quote from: nithya1224 on 22 Aug 2014 01:32:39 PM
You mean no masterdetail relationship between crosstab and data deck . I dint understand the steps.
1) Create a data deck and add four active control values (mapped dataitem) in data deck
2) Set the default card to Yes
3) Drag a Cross tab and should I add a master detail link between data deck and crosstab
You had mentioned no link, then how will it be connected with data deck.
Thanks,
Nithya

The crosstab on the "normal" cards of the data deck uses a master/detail link to limit the display in the crosstab to what is driving the card

The crosstab on the "default" card of the data deck is for all variable values, therefore does not need a master/detail link

MF.
Meep!