· 7 years ago · Sep 04, 2018, 03:38 PM
1
2
3
4
5Conditional styling
6Drill down
7Auto Drill
8Auto Link
9OLAP
10Filter
11Convert Report to chart
12Different output type formats
13Appling themes ,styling, Header and footer, Column total and row total.
14Hold Files
15Define and compute
16Slicers
17User selection
18Report with TOC
19Test to create report with Pages on demand, Accordion, Repeat Sort Value, Stack Measures
20
21
22
23
24
25
26
27
28
29
30
318201 - filters - 6
32
33******Verify Static Filter based on user Defined field*******
34
35
368201 - Auto Drill - 3 (MUST)
37
38***** Verify Auto Drill Report with Auto Link and Multi Drill, using wf_retail_lite*****
39
40REMAINING:
41
428202 - INtegrating with BI PORTAL*****
43
44*****ALL 3 Test cases are doubt**** 3
45
46
478201:
48
494. autoprompt in parameterized...Concept problem..1
50
51INtegrating with BI PORTAL***** 3
52
53*****ALL 3 Test cases are doubt**** 3
54
55****CUBES fully remaining - ESSBASE???**** 3
56
57***MAster Baseline*** Have to try........Source need?? 3
58
59****DOCUment mode****** 10 testcases
60
61
62
638204:
64
65Gray out
66
67
688201:
69****INFOMINI - series tab, resources/field tAB???****
70
71****AutoPrompt???? didn't do........****
72
73
74****CUBES fully remaining - ESSBASE???****
75
76
77****Parameterized????****
78
79***MAster Baseline*** Have to try........Source need??
80
81
82
83
84How Aggregrate function works in particularcolumn->more-> Aggregation???
85
86Dynamic Group??? canada & united states...????/
87
88
89Use of Cordinated Bucket in document?????
90
91
92
93
94PARAMETERIZED:
95
961. Report using parameterized fields
97
98sum cont. -> New parameter...add 3 fields...By cont. -> New parameter...add 2 fields...
99
100Preview show total sum of 3 fields for every product...
101
102Run...Ask 2 dropdown....Choose and get separate vaslues...
103
1042. Document using parameterized fields
105
106Same as report...Document for report....
107
1083. Chart with Parameterized fields and Dynamic Group
109
110Same as report...Chart for report....
111
112Select customer,country in matrix-> rows...create group.....
113
114output shown in group format...
115
116
117
118
119
120
121
122DEFINE:::
123
124DEFINE is an optional attribute used to create a virtual field for reporting. You can derive the virtual field value from information already in the data source (that is, from permanent fields). Some common uses of virtual data fields include:
125Computing new numerical values that are not on the data record.
126Computing a new string of alphanumeric characters from other strings.
127Classifying data values into ranges or groups.
128Invoking subroutines in calculations.
129Virtual fields are available whenever the data source is used for reporting.
130
131Example: Defining a Field
132The following shows how to define a field called PROFIT in the segment CARS:
133SEGMENT = CARS ,SEGTYPE = S1 ,PARENT = CARREC, $
134 FIELDNAME = DEALER_COST ,ALIAS = DCOST ,USAGE = D7, $
135 FIELDNAME = RETAIL_COST ,ALIAS = RCOST ,USAGE = D7, $
136 DEFINE PROFIT/D7 = RETAIL_COST - DEALER_COST; $
137
138Use standard COMPUTE syntax to add a calculated value to your Master File. You can then access the calculated value by referencing the computed fieldname in subsequent TABLE requests. When used as a verb object, as in the following example, the syntax is SUM (or PRINT) COMPUTE field.
139The following is the SALESTES Master File (the SALES FILE modified with an embedded COMPUTE):
140FILENAME=SALESTES, SUFFIX=FOC,
141SEGNAME=STOR_SEG, SEGTYPE=S1,
142 FIELDNAME=STORE_CODE, ALIAS=SNO, FORMAT=A3, $
143 FIELDNAME=CITY, ALIAS=CTY, FORMAT=A15, $
144 FIELDNAME=AREA, ALIAS=LOC, FORMAT=A1, $
145
146SEGNAME=DATE_SEG, PARENT=STOR_SEG, SEGTYPE=SH1,
147 FIELDNAME=DATE, ALIAS=DTE, FORMAT=A4MD, $
148
149SEGNAME=PRODUCT, PARENT=DATE_SEG, SEGTYPE=S1,
150 FIELDNAME=PROD_CODE, ALIAS=PCODE, FORMAT=A3, FIELDTYPE=I, $
151 FIELDNAME=UNIT_SOLD, ALIAS=SOLD, FORMAT=I5, $
152 FIELDNAME=RETAIL_PRICE, ALIAS=RP, FORMAT=D5.2M, $
153 FIELDNAME=DELIVER_AMT, ALIAS=SHIP, FORMAT=I5, $
154 FIELDNAME=OPENING_AMT, ALIAS=INV, FORMAT=I5, $
155 FIELDNAME=RETURNS, ALIAS=RTN, FORMAT=I3, MISSING=ON, $
156 FIELDNAME=DAMAGED, ALIAS=BAD, FORMAT=I3, MISSING=ON, $
157
158 COMPUTE REVENUE/D12.2M=UNIT_SOLD*RETAIL_PRICE;
159The following TABLE request uses the REVENUE field:
160TABLE FILE SALESTES
161HEADING CENTER
162"NEW YORK PROFIT REPORT"
163" "
164SUM UNIT_SOLD AS 'UNITS,SOLD' RETAIL_PRICE AS 'RETAIL_PRICE'
165COMPUTE REVENUE;
166BY PROD_CODE AS 'PROD,CODE'
167WHERE CITY EQ 'NEW YORK'
168END
169The output is:
170 NEW YORK PROFIT REPORT
171
172 PROD UNITS
173 CODE SOLD RETAIL_PRICE REVENUE
174 ---- ---- ------------ -------
175 B10 30 $.85 $25.50
176 B17 20 $1.89 $37.80
177 B20 15 $1.99 $29.85
178 C17 12 $2.09 $25.08
179 D12 20 $2.09 $41.80
180 E1 30 $.89 $26.70
181 E3 35 $1.09 $38.15
182
183
184
185
186
187
188
189Column styling:
1901.table styling home -> Style
1912.Particular column Styling
1923. Header & Footer style
1934. alternate colour home -> Banded
1945. Traffic light -> field->trafficlight-> Greater than value-> style blue-> Value greater cell shown in blue colour.
1956. DrillDown (field) -> Navigating to other report or webpage
1967. Cell Padding -> Layout-> set value (for cell content)
1978. AutoDrill -> Format -> AutoDrill(for field) (Navigating to sub category) (Try with chart)
1989. auto linking
19910. Convert Report to Chart
20011. Types of output
20112. Total row count & Col count
20213. Pages on Dermand -> Run(Show new window, v can navigate by typing pgno.)
20314.STACK MEASURES -> All measure fields in the report are stacked.(quantity and revenue for each product)
20415. SLICERS -> Add field to slicer by dragging from data pane. -> Will get report based on slicer condition
205
206
207
2082.Particular cell Styling??possible?
2096. link for Column title??possible?
210
2111. AUTO LINKING ReportTarg not showing?? is Column name should be same? What is parameter in that??
212MULTI DRILL??
2132. Filter concept -> If productname is true na, not showing...
2143. Parameter - simple, static dynamic
2154. Define, compute Joins and HOLD???
2165. SLICER Why we go for new group if we have option of adding more field in one group??
217
218
219
2208201:
221
222
223Revenue -> Edit format -> Date -> Reset doesn't work.
224
225
2261. Verify, create and save Hold Files:
227
228Create Report(4 field) and save file(Clicking File button) as File1(Temporary)
229
230click Create report(in bottom)(new report).it will show only that 4 field we hold. with fields(3 fields - normal report)
231Run and save it in WFC(file name: C2340)(normal Report save process)
232
233
234Logout and open homepage, open C2340 file and click report it will show 3 field
235
2362. Verify HOLD with Joined files:
237
238Data tab -> Join -> add new -> new master data-> trainig and locator.
239
240REMOVE JOIN ->OK ->PIN Field Drag == HAVE TO ASK
241
242Same as Firat on e document except for report
243
244
2453. Verify create, save and restore HOLD file using Document mode:
246
247Create Document(5 field) and save file(Clicking File button) as c2311(Temporary)
248
249click fields and create document in page1(3 fields - normal report) and click insert->page and create document in page2(2 fields)
250Run and save it in WFC(file name: C2311)(normal Document save process)
251Logout and open homepage, open C2311 file
252
253
2544. Verify promoting HOLD file to Document mode:
255
256Create Report(4 field) and save file(Clicking File button) as File1(Temporary)
257
258click Create report(in bottom) select-> document-> Active report(PDF) with fields(3 fields - normal report)
259Run and save it in WFC(file name: C2068426)(normal Report save process)
260Logout and open homepage, open C2068426 file and it will show 3 fields with data pane contains 4 fields
261
262
263
264
265JOIN:
266
2671. Simple Data JOIN(Did in hold -2)
268
2692. Join training and locator MD through Add new
270 Verify filter is EMPDATA.PIN = LOCATOR.PIN.
271
2723.
273
274
275DEFINE:
276
2772. select Car Field and click data -> Define
278
279enter DEFSALES and double click SALES ...DEFSALES added to data pane...
280
281DOUBLE click DEFSALES....ADDED to report
282
283
284
285COMPUTE:
286
2871.select Car Field, select productcat, revenue and click data -> Compute
288
289enter NEWREVENUE and double click REVENUE ...NEWREVENUE added to Query pane and show in report.
290
291Edit NEWREVENUE and add 9999 and run..Verify changes in report...
292
293
294FILTERS:
295
2961.Filter sales with value 13000-------
297
298Create report with country and sales,
299
300Drag sales to filter and adjust value using getvalue and doubclick 13000..then ok..
301
302Now report shows only with sales value 13000 country..
303
3042. Filter AREA with value CORPORATE in Dynamic parameter-------
305
306AREA Value choose dynamic and run...
307
3083. Filter static----
309
310Only selected values shown (bmw, Audi)during runtime whereas dynamic all values are showed in that we select (corporate)
311
3124. Filter Dynamic with multi values---
313
314select dynamic-> multi- select
315
316select any multiple values during runtime
317
3185. Verify Dynamic Filter based on Joined field----
319
320join 2 md and filter vendor name with select multiple values
321
322
323
324
325
326SLICER:
327
3281.Verify create Slicer by drag and drop----
329
330
331Create slicer by drag and..
332
333select values by clicking ctrl. run
334
335
3362. Verify create Slicer from field context menu in the Data pane----
337
338Create slicer by rightclick..
339
3402nd field add to existing group. run.
341
3423.Verify cascading Slicers with Hierarchical data----
343
344multiple field in same group...Prod.cat, prod.subcat, model....
345
3464. Verify create Slicer group from options Ribbon----
347
348Create new group from slicer-> Newgroup (group2)
349
3505. Verify Slicer based on a joined field----
351
352Create joined Field JOINDEFEXPENSE.
353
354Drag that field to slicer group. and select expense greaterthan 3000.Run..
355
356
3576. Pending----
358
359
360Convert report to Chart:
361
3621. Verify styled Report then convert to Chart-----
363
364Crete reort and apply style for data in a field. convert into chart and save.
365
366Switch to report and save with another name....
367
3682. Verify converting joined Report with Filter to Chart mode----
369
370Crete join report and join field JOINDEFEXPENSES. Drag this field to filter. set expense value greater than 3000.
371
372Run and convert to chart and save... Again switch to report and save with new name....
373
3743. Verify convert report to chart-----
375
376Convert created report to chart and save.
377
378Click exit. Will prompt for saving report.Click no...
379
380
381Auto DRill:
382
3831. Verify Report with Auto Drill using carolap-----
384
385set autodrill for country field. Run. it will show drill up and drill down...
386
3872. Verify Auto Drill Report with Auto Link and Multi Drill, using wf_retail_lite-----
388
389cretae chart and save c2. create report with product and enable auto drill...
390
391then click drilldown(for multi drill) and select chart we created. then create a new drilldown (web page).
392
393Run... it will show both autodrill (Product subcat) and multidrills (chart, webpage)
394
3953.
396
397
398
399
400AUTO LINK:
401
4021. Enable Auto Link and verify available Auto Link Targets from IA and repository tree------
403
404create report(3f- car, model, dealercost) and add car and model to filter pane. enable autolink target and save as target.
405
406Create report(3f- car, model, sales) and enable autolink and save as source.Run source...It show hyperlink in model field....
407
4082. Verify available Auto Link Targets on two different columns-----
409
410Create report with Car, retcost. car in filter...enable autolink target...Save as target2...
411
412Create report with car, model, sales and enable autolink....save as source2...
413
414Run source 2...both car and model in hyperlink.. Car-> target2, model -> target(Check 1 que).
415
4163.Verify Auto Link Targets with multiple drill downs------
417
418in first que, source is created with autolink for model.
419
420Enable drill down for model field and browse report like target. and new target like webpages.
421
4224. Verify Chart with Auto Link and Multi Drill using wf_retail_lite-----
423
424create chart with prodcat, revenue. Enable AUtolink...save as chart_Source1
425
426Create chart with prodcat, Grossprof.Drag Prodcat to filter pane. Enable AUtolink target...save as chart_Target1...
427
428Run chart_source1. it show autolink... Then for multi drill, click prodcat in source and enable drilldown and choose webpage...
429
430Run it will show both drill and link....
431
4325.Verify Chart with Auto Link, Auto Drill, and Multi Drill using wf_retail_lite-----
433
4344th ques source file enabled auto drill option...run...
435
436
437
438DRILL DOWN:
439
4401. Verify Report with Multi Drill-----
441
442Create report and select a field and enable drilldown.dialog box, select webpage and type address...Run....
443
4442. Verify create a report then drilldown to a report----
445
446create report and save report1.
447
448Create report and select a field and enable drilldown.dialog box, browse report1 and click ok...Run....
449
450
4513.Verify create a report then drilldown to an URL and with Description----
452
453Same as first, create report and drill down to webpage with own description....
454
455
4564. Verify drilldown to FEX with Parameters-----
457
458create report with lastname, currsal. Drag dept to filterpane and save report2..
459
460Create report with empid, lastname, currsal... enable drilldown(report2) for currsal ... if v run na, clicking currsal will ask department as department is filter column in report2.
461
462so, we pass parameter in drilldown dialog box, send department mis...run.....it will show only lastname, currsal of MIS department...
463
4645. Verify Parameters can be edit and delete
465
466Edit drilldown dialog parameter and remove...
467
4686. Verify Chart with Multi Drill and Auto Drill using wf_retail_lite
469
470Same as autodrill - 2 question...
471
472
473
474REPORT MODE:
475
4761. Verify Theme from Legacy Templates
477
478Create rpeort and click theme. then apply theme from legacy templates.
479
4802. Verify new Theme from Templates
481
482Create report and click theme. then apply theme dark.sty from templates.
483
4843. Verify adding styling to report
485
486Create report and apply style like fontcolour, bgcolour....
487
4884.Verify adding column total and row total to report
489
490Create Report and select col total and row total...Run and check...
491
4925. Verify report with TOC (Table of Contents)
493
494Create Report and select format->TOC
495
4966. Verify report with Pages on Demand
497
498Create Report with more rows and select format->Pages on Demand
499Run will show report in pagetool (Page1)... ill navigate to any page.....
500
5017. Verify report with Title Popup, Accordion, Repeat Sort Value, Stack Measures
502
503Create report and select format -> titlepopup. If we hover prodcat it will show prodcat..
504
505format -> Accordion.... It will show subcat with plus sign....
506format -> repeat Sort values....It will show coffee category for all three subcategories...
507format - > Stack measure Row header will be given for all rows...
508
5098. Verify Preview and Run Time Record Limit
510
511Slicer -> record (Preview limit -10) and runtime limit - 15) in preview it ill show 10 and in run mode it ill show 15 records....
512
5139. Change Report Margins
514
515Layout -> Margin (1.00 inch all round). Run. margin set for all fourside in repoprt...
516
51710. Verify style Report with background color, font color, font size, justification
518
519Home->Style...Change the styles and run...
520
52111. WITHIN report and aggregation
522
523Select cost field and click aggregation (Under display) by country...Run...it will show total of country in all rows which comes under particular country....
524
52512. Report with Page Break, Line Break, Subtotal, Sub Header and Footer
526
527Select field and apply all styles....
528
52913. Verify Excel Formula request
530
531Select excel formula output.. Ill give excel download file...
532
533Logout and reopen and verify excel formula xlsx is checked
534
53514. Verify Sample Data
536
537Select use simple data..it will show simple data...
538Then data from source...It will show data from master data..
539
540
54115. Verify Query view
542
543Drag product from by to filter... logout and check query.., It should show prodcat in filterpane and also in query pane... same ...
544
545
546
547DOCUMENT MODE:
548
5491. Verify activating Document mode from Home Tab
550
551Create report and convert to document and verify. Select pdf output format...
552
553Logout and check report... Pdf choosed and document mode enabled...
554
5552.
556
557
5583. Verify Document with a Define field in the request
559
560Open document..Insert-> Chart..field select...Data-> define..Define dialog box-> field name, dc field...
561
562Run and verify Define field in output...
563
5644.
565
566
567
5685. Verify a Document with Multiple Pages
569
570
571
572
573OUTPUT FORMAT: (1-3)
574
575Verify all format available. And choosing format giving output....
576
577Logout and check whether selected format is enabled...
578
579
580
581CHART MODE:
582
5831. Verify Chart to Report Conversion-----
584
585create chart and convert to report by clicking report... we can switch report and chart in switch report menu...
586
5872. Verify Hold with Chart mode----
588
589Create chart and check file(is disabled). if we change output format html, it ill be enabled...Click and save..
590
591Run will show ERROR..
592
5933. Verify promoting Chart to Document mode
594
595Create Chart and convert to document by clicking document...
596
597Check switch report..ill show chart1 and document1...move to doc1 and save....close...unsave chart1...
598
599logout and check for doc1...
600
601
6024. Verify InfoMini with Chart mode
603
604
605Create chart and select infomini and select resource/field tab and series tab...save and run....
606
607output shown in infomini toolbar....
608
609We add field and add filter in infomini.. run and save.....
610
611
6125. Verify restore Compute field in Chart mode
613
614we did compute for report in compute ques... Same followed for chart....
615
616
6176. Save and restore Chart: Choropleth Map
618
619Click choropleth map and drag country to layer... Country becomes blue...
620
621Drag continent to color layer... Continent becomes color.....
622
623
624FIELD OPTIONS:
625
6261. Verify Sorting on Dimension and Measure
627
628Drag product to query pane(Across container) and select field-> down.. It show product in descending order...
629
630Drag costgoods to query pane(sum container) and select field-> down... it will show cost of good for all product from high amt to low...
631
6322. Verify hiding visibility (NOPRINT) on Dimension and Measure
633
634Drag prod.cat to (By Cont.) Drag cost of goods, Gross prof to (Sum cont.) Drag Sale,year to (ACROSS cont.)
635
636Click field in querypane.. And hide any u want.... It wont show whole field(With data)....
637
6383. Verify Rank field option
639
640Create report and select field and click field-> Rank.. It will assign rank for field..(1,2,3,)
641
642Delete one field and check....
643
6444. Verify Changing the field Title
645
646Create report and right click field in query pane and change title....
647
6485. Verify Aggregation Function
649
650Select Field and Click Field-> Aggregration-> Average....It ill show avg.Costofgoods..
651
652Click Field-> Aggregration-> Percent....It ill show PCT.Costofgoods..
653
6546. Multiple Traffic Lights conditions using "New" option and styling for each condition
655
656Select field field-> Traffic lights... Enter value and asssign style for that particular value...
657
658Add style for second value by clicking "new" repeat same process..
659
6607. Verify deleting Traffic Lights condition
661
662Select field field-> Traffic lights. Select the Field and delete in Traffic light dialog box....
663
664
665INFOMINI:
666
667
6681. Verify InfoMini request with Chart mode----------
669
670cREATE CHART and seelct format->Infomini...select series and resource/field tab...Run...
671
672Chart shownm in Infomini application...Click edit and check seies tab exist and edit mode..
673
674Change chart type to pie. format-> Chart type->pie... Series->Datalabels...Labels in pie chart..
675
676
6772. Verify InfoMini request with Report mode ***Report instead of chart****------------
678
679cREATE Report and seelct format->Infomini...select resource/field tab...Run...
680
681Report shownm in Infomini application..
682
683
6843. Verify InfoMini request with Document mode----------
685
686cREATE Document and seelct format->Infomini...select insert tab and resource/field tab...Run...
687
688Document shown in Infomini application..
689
690
691
6924. InfoMini Report using Slicers-------------
693
694Drag product to slicer tab...choose avlues in slicer tab...Run...
695
696Report shown in infomini aoolication....
697
698in IM we change the slicer value and run..
699
700
701
702REPORTING OBJECT:
703
7041. Verify a Reporting Object with Report and Chart
705
706Open reporting object...DC Report and create report and save.exit...
707
708DC Chart and create Chart and save.exit... Run Reporting Object...
709
710It show op with radio button run report and run graph button. If v click run report means, it shows report. same for chart..
711
712
7132. Verify creating a Report based on a Reporting Object
714
715Open report page which we created in 1st question and save Click "IA" > "Close" > Click "Yes" to save prompt>Save as>c234
716
717Then open c234 and verify...
718
7193. Verify creating a Document based on a Reporting Object
720
721Open document page in Reporting object.. Reposition report and chart..Save as c334...
722
723Then open c334 and verify...
724
7254. Verify conversion with Report based on a Reporting Object----------
726
727Open report in Reporting object...convert report to chart ->click Chart...convert report to Document ->click Document...
728
729Save both doc and chart with separate name....
730
731
7325. Verify creating a Reporting Object with Filter--------------
733
734open filter in reporting. ANd apply filter with prodcat.... create report and chart ...Save... save repoirting object...
735
736Select prodcat in filter pane...Click include...verify Filter applies to report and cahrt....
737
738Open document(Saved file).... Page option in document mode...duplicate page and open ...verify...
739
740
7416. Verify creating a Reporting Object with WHERE condition-------*********
742
743
744Same as 5th question....
745Insert->Report and create report...Verify the where filter condition is applied to that new report....
746
7477. Verify Alert Assist save and restore
748
749Open alert tool... test-> new report...create report and save....
750
751Result-> New report..create report and save....
752
753Save alert..AA->Saveas...Reopen and Verify.....
754
7558. Verify Join and Define field created in Reporting Object
756
757Open reporting object...Join-> new ->training.mas->ok
758
759define->new->expression->ok...
760
761Click report and verify whether join field and define_1 is in data pane....
762
763
764
765
766PREFERENCES:
767
7681. Verify default User Preferences values------------------
769
770Create report and select ia-> Options. verify chart output type formats are available...
771
7722. Verify Global Preferences default values---------------
773
774http://qawin7-03:8080/ibi_apps
775
776Select "Administration" > "Administration Console".Verify options...(File option, chart type, auto drill, home tab, allow user override)
777
778
7793. Verify request with User Selection--------------
780
781http://qawin7-03:8080/ibi_apps
782
783Select "Administration" > "Administration Console"."InfoAssist Properties" > Check off "User Selection" Show checkbox.
784
785Then create Report and run...It will ask output. select active output format and run...Verify getting active output....
786
7874. Verify Global Preferences default values are correct after restoring default values.--------
788http://qawin7-03:8080/ibi_apps
789
790Select "Administration" > "Administration Console"."InfoAssist Properties" > change default chart op format html5 to pdf -> open..
791
792Open Ia and create chart...default op format it ill show PDF....Then, again open and click restore default values...
793
794
795DBINFILE:
796
797
7981. Request with Subquery (DBINFILE)
799
800Create hold file(create report and click file to save) with filter....
801
802Create normal report from md(By data->switch->Masterdata).....
803
804Apply filter for normal report...type->Subquery, inlist <subquery> ->File1(Hold file name)...(Now filter applied in hold file applied to normal report...)
805
806
807
808AUTOPROMPT:
809
8101. Responsive Autoprompt- All values check box should be checked after running with the filter values
811
812In Autoprompt window, Verify that "All"check box is checked for Country values...Run...ill show op based on all filter values...
813
814
815
816CONTEXT MENU:
817
8181. Verify Data Pane context menus
819
820Click dimension field and add slicer and check options...
821
822Click Measure field and add to existing slicer and check options...
823
824Add field to by cont. accross cont. and verify op.....
825
8262.
827
828
829
830
831
832Test Splash Screen and Switch Reports shortcut--------
833
834create report...ia->new->build a chart... ia->new-> build a document.... ia->new->builsda visualization...Just switch visual to report, report to chart....verify...
835
836Verify arranging output windows in Cascade, Tile Horizontally, Tile Vertically----------
837
838Create report and set output as newtab....then, view->Arrange->cascade,tile hori, tile verti
839
840Verify Query panel Views 2x2, 1x4-------
841
842Pane format...View->Areas2*2
843
844
845
846DYNAMIC GROUP:
847
8481. Report with Dynamic Group ***What is the use****
849
850Create group from customer,country(By cont.)...Canada and us....Verify report it show countryname1 canada and us in single row(Grouped)
851
8522. Document with dynamic group
853
854Create group from customer,cussiness region(By cont.)...Canada and us....Verify document datapane and query pane it show countryname1..
855
856
857BrowserSpecfic:
858
8591. Verify Report with Header&Footer
860
861Normal header & Footer option and verify..
862
863
864
865MASTER BASELINE:
866
8671. Verify Traffic Lights condition with 'From file' option
868
869Select Field and Click "Traffic Lights" (Default = Greater than) > dropdown button > "Get Values" > "From File".
870
871"Choose File" > Browse \ibirisc2\bipgqashare\QA_XL_CSV_FILES\S10032 > Select "Flat-File-Data-for-0027.txt"
872
873Verify the "Values" textbox is populated with the flat file data.select value and verify traffic light signal in report....
874
875Same for excel file....
876
877
878
879
880
881
8828202:
883
8841. Verify SET commands default settings, syntax, save and restore:
885
886Click procedure Settings and source code and verify
887
888Changes Procedure setting values and add fields in report and save
889
890Logout and reopen. verify procedure settings (Equals changed values)
891
892
8932. Verify SET command for Missing Value with Join in request
894
895Data-> Join(Training - md) create report (4 Fields)
896
897Set Missing value as none and verify live preview
898
899Save and logout. Then open and verify procedure (It should show missing value as none)
900
901
9023. Verify SET commands are carried over when promoting Report to Document mode
903
904Create Report and change procedure settings value(Noval for missing value)
905
906Click home -> Document (Report changed to document)
907
908Run and save. Logout.
909
910Reopen saved document and verify procedure setting values(It should be noval for missing values)
911
912
9134. Verify SET Command for Missing Value with multiple queries
914
915Create Report and change procedure settings value(N/A for missing value)
916
917Select new->Build a chart -> Carolap(md)
918
919Select report1 from status bar and save.Logout.
920
921Reopen saved document and verify procedure setting values(It should be noval for missing values)
922
923
9245. Verify SET Command for Decimal Notation
925
926Create Report and change procedure settings value(On for Decimal notation)
927
928Run and save.
929
930Reopen and click chart and check Decimal notation value( It shouldn't be clicked - not carried over(after save))
931
932save chart and verify
933
934
935
936CURRENCY OPTIONS:
937
9381. Verify Currency Formats displayed in the Field Tab ribbon, Define and Compute dialogs
939
940Select any measure field and verify currency options.... after enabling define and verify...like same for compute...
941
942
9432. Verify Currency Formats selection is reflected in the Field Tab drop menu
944
945Select field and change Format option from decimal to euro and verify...
946
9473. Verify Currency Options with SET CDN=ON
948
949Select measure field and change currency to euro..it will be with 2 decimal point...
950
951Click procedure setting and check off decimalnotation - on and run... It will show dot instead of comma and comma instead of dot....
952
9534. Verify multiple Currency Formats in Document Mode
954
955Create document and select euro. Then insert-> report doubleclick 2 fields and set current floating japanese yen...
956
957Then insert-> page. Doubleclick 2 fields and create create page2 document.. Run and navigate to page2 and verify....
958
9595.
960
961
962HOLD:
963
9641. Verify hold JSON format in Report mode
965
966Create Hold file and save as JSon format. and save report.
967
968Create report(from bottom menu)(2 fields) from that hold file(4 fields) and save.
969
970Reopen and verify. It show only 2 fields and in data pana only 4 fields...
971
9722. Verify hold JSON with Chart conversion ***CHART from bottom menu***
973
974Create Hold file and save as JSon format in foccache folder.
975
976create chart(from bottom menu)(2 fields) from that hold file(4 fields) and save.
977
978Reopen and verify. It show only 2 fields and in data pane only 4 fields...
979
9803. Veify hold JSON format in Document mode ***DOCUMENT from bottom menu***
981
982Create Hold file and save as JSon format in foccache folder.
983
984create Document(from bottom menu)(2 fields) from that hold file(4 fields) and save.
985
986Reopen and verify. It show only 2 fields and in data pane only 4 fields...
987
988
989
990DEFINE:
991
9921. Verify field Titles in the Define dialog-----**** whats the use of changing format? What is the use of use field titles enabled?
993
994Create report and select Define.In define dialog box, verify usefieldtitle is selected by default..
995
996Double-Click field and verify data pane withj defin_1 exists...
997
9982. Verify the expected qualified NAME is displayed while setting is "Use field titles" and MFD does not have titles
999
1000Create report(sales) and select Define.In define dialog box, verify usefieldtitle is selected by default..
1001
1002Double-click country and ok. Then doubleclick define_1 from datapane and verify report....
1003
1004THUMBNAIL:
1005
10061. Verify create and modify thumbnail
1007
1008Create chart and select Thumbnail and save....Edit properties in domain tree and check thumbnail in (Advanced tab).
1009
1010Reopen and edit chart and select thumbnail. and check properties...
1011
1012THEMES:
1013
10141.Verify push buttons and split menus in default IA Theme
1015
1016
1017Just check Clicked buttons in ribbon are enabled in blue colour...
1018
1019Check Dropdown button click show in blue colour...
1020
1021
1022CHART MODE:
1023
10241. Verify Hold with Chart mode
1025
1026Create chart(3 fields)...file is in disabled mode...Change format html5 to html...File is enabled....click file and save....
1027
1028Reopen and run... It will show error..As we do temp file run...
1029
1030
1031API:
1032
10331.API > Launch InfoMini Application
1034
1035Create report and select Infomini...
1036
1037Reopen and run.. It will open infomini
1038
1039
1040
1041INTEGRATE API
1042
10431. API > BIP > Launch IA
1044
1045BIP Tools n
1046
1047
1048
1049COMPUTE:
1050
10511. Verify field Titles in the Compute dialog
1052
1053Create report and select Compute.In define dialog box, verify usefieldtitle is selected by default..
1054
1055Double-Click fields and do calculation(cost- revenue) and verify data pane with compute_1 exists...
1056
1057Reopen and verify compute_1 edit shows(cost- revenue)...
1058
10592. Verify PARTITION_REF function---- ***Partition ref query???***
1060
1061Create report and compute with partition ref query. Then run and verify...
1062
10633. Verify PARTITION_AGGR function-----***Partition Aggr query???***similar TRYY
1064
1065Create report and compute with partition aggr query. Then run and verify...
1066
10674. Verify Report with a Compute field----
1068
1069Create report and select Compute. Select revenue field and add 9999 and cahnge field name new_revenue and ok... run and verify..
1070
1071Reopen and check Newrevenue_1 edit possible....
1072
1073
1074
1075
10768203
1077
10781. Verify Sort by dynamic prompt
1079
1080Create Report and drag sale,date to filter. Right-click sale,date and select filter.
1081
1082type-> parameter -> dynamic -> desencending.Run... report show dropdown dates in descending order.
1083
1084save and reopen and change descebnding to ascending and check output.
1085
10862. Verify single-select Dynamic Filter using Define from master
1087
1088
1089Same as one - Area in filter and getting report..
1090
1091
10923. Verify multi-select Dynamic Filter
1093
1094Drag country to filter and set parameter dynamic and multiselect.
1095
1096Create report with country and sales.Run.
1097
1098in output we can select multiple country and run it will show only 2 selected country with sales...
1099
1100
11014. Error - HAVE TO ASK
1102
1103
1104
1105REPORT MODE
1106
11071.Verify HFREEZE - SCROLLHEIGHT=AUTO---------
1108
1109create report selct format-> Freeze...Run....
1110
1111Ill allow to scroll till last data...Verify source for HFREEZE = ON - SCROLLHEIGHT=AUTO
1112
1113
11142. Verify download data with output format CSV--------
1115
1116Create Report and select Excel(CSV) format.
1117
1118Run ...It will download cav report open and verify...
1119
11203. Verify new Accordion Report--------
1121
1122Create port and select format-> Accordion..
1123
1124Run and verify output and source code Expandable on..
1125
11264. Verify report with Title Popup, Accordion, Repeat Sort Value, Stack Measures-------
1127
1128Already DID
1129
1130
1131PREFERENCES:
1132
11331. Verify default User Preferences values------------------
1134
1135Create report and select ia-> Options. verify chart output type formats are available...
1136
11372. Verify Global Preferences default values---------------
1138
1139http://qawin7-03:8080/ibi_apps
1140
1141Select "Administration" > "Administration Console".Verify options...(File option, chart type, auto drill, home tab, allow user override)
1142
1143
11443. Verify request with User Selection--------------
1145
1146http://qawin7-03:8080/ibi_apps
1147
1148Select "Administration" > "Administration Console"."InfoAssist Properties" > Check off "User Selection" Show checkbox.
1149
1150Then create Report and run...It will ask output. select active output format and run...Verify getting active output....
1151
11524. Verify Global Preferences default values are correct after restoring default values.--------
1153http://qawin7-03:8080/ibi_apps
1154
1155Select "Administration" > "Administration Console"."InfoAssist Properties" > change default chart op format html5 to pdf -> open..
1156
1157Open Ia and create chart...default op format it ill show PDF....Then, again open and click restore default values...
1158
1159
1160
1161SET COMMANDS:
1162
11631. Verify SET commands default settings, syntax, save and restore:
1164
1165Click procedure Settings and source code and verify
1166
1167Changes Procedure setting values and add fields in report and save
1168
1169Logout and reopen. verify procedure settings (Equals changed values)
1170
1171
11722. Verify SET command for Missing Value with Join in request
1173
1174Data-> Join(Training - md) create report (4 Fields)
1175
1176Set Missing value as none and verify live preview
1177
1178Save and logout. Then open and verify procedure (It should show missing value as none)
1179
1180
11813. Verify SET commands are carried over when promoting Report to Document mode
1182
1183Create Report and change procedure settings value(Noval for missing value)
1184
1185Click home -> Document (Report changed to document)
1186
1187Run and save. Logout.
1188
1189Reopen saved document and verify procedure setting values(It should be noval for missing values)
1190
1191
1192CONTEXT MENUS:
1193
11941.Verify Ribbon menus-----
1195
1196Slicer -> record (Preview limit -10) and runtime limit - 15) in preview it ill show 10 and in run mode it ill show 15 records....
1197
1198run dropdown -> Preview. Verify preview op.
1199undo action, Hide and show ribbon, Help- verify
1200
1201
1202DEFINES:
1203
1204
12051. Verify changing order of DEFINE fields
1206
1207Select data -> Define...Create define_1 -> CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST
1208
1209Create define_2 -> CAR.BODY.DEALER_COST...Create define_3 -> CAR.BODY.RETAIL_COST.. View source...
1210
1211Order will be define_1 define_2 define_3... Edit Define_1 -> Define_3 - CAR.BODY.DEALER_COST...
1212
1213Now check view source -> Order will be define_2 define_3 define_1... add 3 defines and run....
1214
12152. Verify Define with Date field type and period separator
1216
1217data-> define...Double-click sale,date...click format ->date (dmyy) separator -> .Period
1218
1219Create report with define_1, prod.cat..Run and verify...
1220
1221COMPUTE:
1222
12231. Verify Compute with Date field type and hyphen separator
1224
1225data-> compute...Double-click hiredate...click format ->date (dmyy) separator -> .hyphen
1226
1227Create report with compute_1, lastname..Run and verify...
1228
1229ADAPTIVE:
1230
12311. Verify enabling Adaptive Dashboard
1232
1233Create document and select layout-> Adaptive dashboard...Verify view source arjson...
1234
1235Reopen and verify....
1236
1237
1238
1239
12408204:
1241
1242THUMBNAIL:
1243
12441. Verify create and modify thumbnail
1245
1246Already Did in thumbnail...
1247
1248
1249
1250FUNCTION:
1251
12521. GIS_DISTANCE in Compute in Report
1253
1254open exiusting report with startstat.name and end stat.name
1255
1256Data-> compute -> f(x) -> Geography(GIS distance - Douclic)
1257
1258Then change parameters in fun as (startstat.name,end stat.name)...field anme -> miles..
1259
1260Run...It show Miles field with differe value...
1261
1262
1263DEFINES:
1264
1265
12661. Verify field Titles in the Define dialog:
1267
1268Already did in field titles....
1269
1270
1271DOCUMENT MODE:
1272
12731. Verify new Theme from Templates with multipage
1274
1275Open document...insert Tab > Click "Report"...Home Tab > Click "Theme" icon...Verify new themes in default "Templates" folder..Select theme...
1276
1277Verify it applied to report....
1278
1279Then Insert->page...Dc field and create report.. Same Process(Home Tab > Click "Theme" icon...Verify new themes in default "Templates" folder..Select theme...)
1280
1281Run and verify both pages....
1282
1283CONTEXT MENUS:
1284
12851. Verify Search field and double click
1286
1287Simple....Already did in contect menu...
1288
1289
1290
1291
1292
12938201:
1294
1295Document mode
1296&
1297Below Output format all are remaining.....
1298
1299
13008202:
1301
1302Integrating with BI Portal - Doubt....
1303
13048203: