FM prompt not work

[Chandrasekar]

Hi Gurus,

I try to create a prompt in Framework Manager. But it not worked. Using cognos 10.1, Relational model

Procedure:

1. Create namespace, Name is Filters and Calculations
2. It follows folder, Name is Prompt.
3. It follows Query subject, Name is Country
4. And it follows Query item, Name is 'Select country Name' and it have macro is (#promptmany('Select Country Name')#)
5. And i choose prompt type is 'Select with tree prompt'
6. And i choose use item reference is [Application Layer].[Country].[Country Name]
7. After publishing package, report shows search & select prompt, but it dnot shows any country name.
8. If any values import, it returns only what entered in that prompt.

How to solve this? Can you help me.

I have one doubt, When enter prompt macros it ask (Model Prompts Manager) values to enter. Here i enter 'All'. If i want to any changes in here.

Thanks & Regards,
Chandrasekar.P

[Chandrasekar]

Hi Gurus,

I change macro function is,

(#promptmany('Select Country Name','string','[Application Layer].[Country].[Country Name]')#).

When i testing this query it gives all the country lists in Framework Manager. But when run in Report Studio, it shows empty search & select prompt. I cant able to select any country name here.(Without using prompt page)

Where i mistake. Please help me to solve.

Additional Information: Once i create Generated Prompt in prompt page(Using this query item) it works. After deleting this prompt page, then also its works. I am confused here.

Thanks & Regards,
Chandrasekar.P

[MFGF]

Hi Gurus,

I change macro function is,

(#promptmany('Select Country Name','string','[Application Layer].[Country].[Country Name]')#).

When i testing this query it gives all the country lists in Framework Manager. But when run in Report Studio, it shows empty search & select prompt. I cant able to select any country name here.(Without using prompt page)

Where i mistake. Please help me to solve.

Additional Information: Once i create Generated Prompt in prompt page(Using this query item) it works. After deleting this prompt page, then also its works. I am confused here.

Thanks & Regards,
Chandrasekar.P

Wouldn't promptmany default to a value prompt rather than a select and search prompt? What filter were you using in your report originally? What filter(s) exist(s) after adding and deleting your prompt page?

MF.

[Chandrasekar]

Hi MFGF,
Thanks for your reply.
Wouldn't promptmany default to a value prompt rather than a select and search prompt? Yes, promptmany set default to search & select prompt, But i changed to select value in prompt info option. Again it shows search & select prompt.(Without country name).
Actually i want, If i select India, Canada means it gives both country code & country name(Without using prompt page). Country Name have this macro (#promptmany('Select Country Name','string','[Application Layer].[Country].[Country Name]')#).  When i run this report it ask a country name from this macro. This method is correct approach?/Any alternate solutions have it?

What filter were you using in your report originally?
I create a POC for Prompt based FM simple package. And Report list have Country code, Country Name. No other filters are used in report.

What filter(s) exist(s) after adding and deleting your prompt page?
Now i clear this, I delete only prompt page, Filter not deleted.

Thanks & Regards,
Chandrasekar.P

[MFGF]

...No other filters are used in report...

No other filters apart from what? What are the defined filters - are there any?

Now i clear this, I delete only prompt page, Filter not deleted.

Yes but what filter remains? You said the report works after doing this - so that indicates the filter remaining is appropriate. What is the expression? Wouldn't you simply need to add this filter in the first instance to get your report to work?

MF.

[Chandrasekar]

Hi MFGF,

No other filters are used in report...

Yes but what filter remains?
If i using generated prompt it automatically enter filter in detailed filter. ('Select Country Name' New prompt query item). If i delete prompt page, filter not deleted.

What is the expression?
[Filters].[Prompts].[Select Country Name] in (?Parameter1?)

Thanks & Regards,
Chandrasekar.P

[MFGF]

Hi MFGF,

No other filters are used in report...

Yes but what filter remains?
If i using generated prompt it automatically enter filter in detailed filter. ('Select Country Name' New prompt query item). If i delete prompt page, filter not deleted.

What is the expression?
[Filters].[Prompts].[Select Country Name] in (?Parameter1?)

Thanks & Regards,
Chandrasekar.P

Hi,

Ok - so all you need to do is to add this filter to your report to get the desired outcome. No need for the prompt page.

Cheers!

MF.

[Chandrasekar]

Hi MFGF,

Everything is fine. Now i see two prompts. One is search & select prompt(empty optional prompt). Next one is value prompt(Value with multi-select option, Required prompt). Why search & select prompt come? 

Thanks & Regards,
Chandrasekar.P