There are two options to set "max number of rows fetched"
from designer,
1. Tools> Options
2. From universe parameters
What is the different between these two and why their valus
are different?
Answers were Sorted based on User's Feedback
Answer / sreenivas27
In Designer
This is a useful feature to show you a sample of the data
in your tables as you build objects in the universe. As a
default, Designer will present
you with the first 100 values in your database
I think ur expecting this one.
Regards,
Sreeivas
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / bouser
you seltect the particular field of table and then right
click you get options thereno of rows in table you click
that u get the table values
Is This Answer Correct ? | 0 Yes | 2 No |
Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
BO Webi report in running fine in Dev but takes a long time to run in Production environment, how to reduce this processing time.
WHAT IS SYNCHRONIZATION IN BOXI?
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
how do you give security to universe ?
2 Answers InfoStep, Tech Mahindra,
I have a report with n number of records. i want to take alternative rows as a red in color. How to make it?
difference between xir2 and 6.5 version
I need to develop cross tab in format: Values D E F A 1 3 4 B 2 5 8 C 9 8 10 My problem is values in header I am able to do same in WEBI how to manipulate same in deski? Plz Help
how u restrict the values?to display 5 values insted of 10 values?
what is data cubes??