HOW TO SPOT A HIERARCHY?
Answers were Sorted based on User's Feedback
Answer / rashmi
Hi
From the designer u can spot the already mentioned hierarchy
and also u can cahnge or edit the same.
Go to Tool->Hierarchies
here u can ether adda new one or can also edit teh existing
one.
| Is This Answer Correct ? | 4 Yes | 0 No |
hirearcyhy are basically 2 types default hie. & cust. hie .
dif. hie. created by default it depends upon no. of classes
and dimen.
cust. her created by the bellow navi.
Tools->hier->cust.hier-> give the name of the hier.->selecte
the obj from default hier. ->click right arrow ->arrange the
order as per cust. requi.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?
how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this
Approximatly how many enduser can use the each bo project?
What is the difference between Thin client & thick client?
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
IS THERE ANY OTHER TOOL AVAILABLE TO DESIGN/CREAT UNIVERSE? EXCEPT UNIVERSE DESIGNER
what is a filter?
Difference between scope of analysis in webi and in deski?
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:)
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.
HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?