Solved

more prompts on infoview than expected

Posted on 2014-09-16
8
281 Views
Last Modified: 2014-09-21
I have some filters using conditions from the universe but I have more prompts than filters

I have for example 7 conditions from the universe they have 10 prompts in them. When I run the report I see 15 prompts. How can i determine where the additional prompts are coming from ?
0
Comment
Question by:pcomb
  • 4
  • 3
8 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40326814
Which reporting tool are you using?

If it is Crystal, do you have a subreport?
Does it have parameters?
If so if they aren't linked to the main report you will get prompted.

mlmcc
0
 

Author Comment

by:pcomb
ID: 40326826
I am using info view it's one report with prompts but I am getting a list of 17 prompts but I can only find 12 so not sure where the others are coming from
I did not create the repprt
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40327071
What reporting tool?
Crystal, DeskI, WebI?

The reporting tool type will help determine how to find the prompts.

If it is a Crystal Report, can you upload the report file?

If it is a WebI it may be helpful to see a screen shot of the Edit Query screen.

mlmcc
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 34

Expert Comment

by:James0628
ID: 40327618
This is something of a shot in the dark, but with the old BO (before the merge with CR), you could create prompts by just entering them in a query, and if you used the same prompt more than once, you had to make sure to spell it the same each time.  If you had a typo, for example, that created a separate prompt.

 If your prompts are anything like that, I'd check the spelling, etc.  Case may or may not be signficant.

 Like I said, just a shot in the dark, but it sounds like it might be something like that.  Maybe some of your "conditions" have prompts that should be duplicates, but aren't, because the names are different.

 James
0
 

Author Comment

by:pcomb
ID: 40327777
hi its Webi
There are no obvious misspellings or duplications

I have a report that uses x conditoins (defined in universe) those conditions contain x +3 @prompts. I have added these conditions to the Query filters section.
However when I run the report I get prompted for x + 6 prompts. none of these are duplicates, there are some for fields that are not in any of the prompts I see in the conditions in the universe.

I cannot see anywhere else these filters could be added?


thanks
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40328401
Are there any mandatory prompt in the universe?
ie if you remove the filters from the reports are there still values prompted for?

One way to try to find them would be to remove a filter the run the query to see the prompt screen

Are any of the prompts date ranges that would generate 2 prompts?

mlmcc
0
 

Author Comment

by:pcomb
ID: 40328455
it seems to be one specific report. If I delete all the prompts from this report I still get prompted. If I use a difference version of that report and delete all prompts I do not get prompted.

I think I may just have to scrap that report as I cant see how its still prompting

thx
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 40328509
There can be objects in the universe that can be added to the select part that include a prompt.  We have several dimensions that have that.  The prompt is to get information from the user to use in the report or in one case to allow the user to choose which of 2 fields to include in the report.

You could start eliminating fields from the select or compare the 2 select lists to see the differences.  Probably one of the objects includes a prompt.  

Are the 2 reports running against the same universe?

mlmcc
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.

823 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question