· 7 years ago · Sep 03, 2018, 03:16 PM
1
28201 - filters - 6
3
4******Verify Static Filter based on user Defined field*******
5
6
78201 - Auto Drill - 3 (MUST)
8
9***** Verify Auto Drill Report with Auto Link and Multi Drill, using wf_retail_lite*****
10
11
12
138202 - INtegrating with BI PORTAL*****
14
15*****ALL 3 Test cases are doubt****
16
17
18
19
20
21
22
23
24
25
26Column styling:
271.table styling home -> Style
282.Particular column Styling
293. Header & Footer style
304. alternate colour home -> Banded
315. Traffic light -> field->trafficlight-> Greater than value-> style blue-> Value greater cell shown in blue colour.
326. DrillDown (field) -> Navigating to other report or webpage
337. Cell Padding -> Layout-> set value (for cell content)
348. AutoDrill -> Format -> AutoDrill(for field) (Navigating to sub category) (Try with chart)
359. auto linking
3610. Convert Report to Chart
3711. Types of output
3812. Total row count & Col count
3913. Pages on Dermand -> Run(Show new window, v can navigate by typing pgno.)
4014.STACK MEASURES -> All measure fields in the report are stacked.(quantity and revenue for each product)
4115. SLICERS -> Add field to slicer by dragging from data pane. -> Will get report based on slicer condition
42
43
44
452.Particular cell Styling??possible?
466. link for Column title??possible?
47
481. AUTO LINKING ReportTarg not showing?? is Column name should be same? What is parameter in that??
49MULTI DRILL??
502. Filter concept -> If productname is true na, not showing...
513. Parameter - simple, static dynamic
524. Define, compute Joins and HOLD???
535. SLICER Why we go for new group if we have option of adding more field in one group??
54
55
56
578201:
58
59
60Revenue -> Edit format -> Date -> Reset doesn't work.
61
62
631. Verify, create and save Hold Files:
64
65Create Report(4 field) and save file(Clicking File button) as File1(Temporary)
66
67click Create report(in bottom)(new report).it will show only that 4 field we hold. with fields(3 fields - normal report)
68Run and save it in WFC(file name: C2340)(normal Report save process)
69
70
71Logout and open homepage, open C2340 file and click report it will show 3 field
72
732. Verify HOLD with Joined files:
74
75Data tab -> Join -> add new -> new master data-> trainig and locator.
76
77REMOVE JOIN ->OK ->PIN Field Drag == HAVE TO ASK
78
79Same as Firat on e document except for report
80
81
823. Verify create, save and restore HOLD file using Document mode:
83
84Create Document(5 field) and save file(Clicking File button) as c2311(Temporary)
85
86click fields and create document in page1(3 fields - normal report) and click insert->page and create document in page2(2 fields)
87Run and save it in WFC(file name: C2311)(normal Document save process)
88Logout and open homepage, open C2311 file
89
90
914. Verify promoting HOLD file to Document mode:
92
93Create Report(4 field) and save file(Clicking File button) as File1(Temporary)
94
95click Create report(in bottom) select-> document-> Active report(PDF) with fields(3 fields - normal report)
96Run and save it in WFC(file name: C2068426)(normal Report save process)
97Logout and open homepage, open C2068426 file and it will show 3 fields with data pane contains 4 fields
98
99
100
101
102JOIN:
103
1041. Simple Data JOIN(Did in hold -2)
105
1062. Join training and locator MD through Add new
107 Verify filter is EMPDATA.PIN = LOCATOR.PIN.
108
1093.
110
111
112DEFINE:
113
1142. select Car Field and click data -> Define
115
116enter DEFSALES and double click SALES ...DEFSALES added to data pane...
117
118DOUBLE click DEFSALES....ADDED to report
119
120
121
122COMPUTE:
123
1241.select Car Field, select productcat, revenue and click data -> Compute
125
126enter NEWREVENUE and double click REVENUE ...NEWREVENUE added to Query pane and show in report.
127
128Edit NEWREVENUE and add 9999 and run..Verify changes in report...
129
130
131FILTERS:
132
1331.Filter sales with value 13000-------
134
135Create report with country and sales,
136
137Drag sales to filter and adjust value using getvalue and doubclick 13000..then ok..
138
139Now report shows only with sales value 13000 country..
140
1412. Filter AREA with value CORPORATE in Dynamic parameter-------
142
143AREA Value choose dynamic and run...
144
1453. Filter static----
146
147Only selected values shown (bmw, Audi)during runtime whereas dynamic all values are showed in that we select (corporate)
148
1494. Filter Dynamic with multi values---
150
151select dynamic-> multi- select
152
153select any multiple values during runtime
154
1555. Verify Dynamic Filter based on Joined field----
156
157join 2 md and filter vendor name with select multiple values
158
159
160
161
162
163SLICER:
164
1651.Verify create Slicer by drag and drop----
166
167
168Create slicer by drag and..
169
170select values by clicking ctrl. run
171
172
1732. Verify create Slicer from field context menu in the Data pane----
174
175Create slicer by rightclick..
176
1772nd field add to existing group. run.
178
1793.Verify cascading Slicers with Hierarchical data----
180
181multiple field in same group...Prod.cat, prod.subcat, model....
182
1834. Verify create Slicer group from options Ribbon----
184
185Create new group from slicer-> Newgroup (group2)
186
1875. Verify Slicer based on a joined field----
188
189Create joined Field JOINDEFEXPENSE.
190
191Drag that field to slicer group. and select expense greaterthan 3000.Run..
192
193
1946. Pending----
195
196
197Convert report to Chart:
198
1991. Verify styled Report then convert to Chart-----
200
201Crete reort and apply style for data in a field. convert into chart and save.
202
203Switch to report and save with another name....
204
2052. Verify converting joined Report with Filter to Chart mode----
206
207Crete join report and join field JOINDEFEXPENSES. Drag this field to filter. set expense value greater than 3000.
208
209Run and convert to chart and save... Again switch to report and save with new name....
210
2113. Verify convert report to chart-----
212
213Convert created report to chart and save.
214
215Click exit. Will prompt for saving report.Click no...
216
217
218Auto DRill:
219
2201. Verify Report with Auto Drill using carolap-----
221
222set autodrill for country field. Run. it will show drill up and drill down...
223
2242. Verify Auto Drill Report with Auto Link and Multi Drill, using wf_retail_lite-----
225
226cretae chart and save c2. create report with product and enable auto drill...
227
228then click drilldown(for multi drill) and select chart we created. then create a new drilldown (web page).
229
230Run... it will show both autodrill (Product subcat) and multidrills (chart, webpage)
231
2323.
233
234
235
236
237AUTO LINK:
238
2391. Enable Auto Link and verify available Auto Link Targets from IA and repository tree------
240
241create report(3f- car, model, dealercost) and add car and model to filter pane. enable autolink target and save as target.
242
243Create report(3f- car, model, sales) and enable autolink and save as source.Run source...It show hyperlink in model field....
244
2452. Verify available Auto Link Targets on two different columns-----
246
247Create report with Car, retcost. car in filter...enable autolink target...Save as target2...
248
249Create report with car, model, sales and enable autolink....save as source2...
250
251Run source 2...both car and model in hyperlink.. Car-> target2, model -> target(Check 1 que).
252
2533.Verify Auto Link Targets with multiple drill downs------
254
255in first que, source is created with autolink for model.
256
257Enable drill down for model field and browse report like target. and new target like webpages.
258
2594. Verify Chart with Auto Link and Multi Drill using wf_retail_lite-----
260
261create chart with prodcat, revenue. Enable AUtolink...save as chart_Source1
262
263Create chart with prodcat, Grossprof.Drag Prodcat to filter pane. Enable AUtolink target...save as chart_Target1...
264
265Run chart_source1. it show autolink... Then for multi drill, click prodcat in source and enable drilldown and choose webpage...
266
267Run it will show both drill and link....
268
2695.Verify Chart with Auto Link, Auto Drill, and Multi Drill using wf_retail_lite-----
270
2714th ques source file enabled auto drill option...run...
272
273
274
275DRILL DOWN:
276
2771. Verify Report with Multi Drill-----
278
279Create report and select a field and enable drilldown.dialog box, select webpage and type address...Run....
280
2812. Verify create a report then drilldown to a report----
282
283create report and save report1.
284
285Create report and select a field and enable drilldown.dialog box, browse report1 and click ok...Run....
286
287
2883.Verify create a report then drilldown to an URL and with Description----
289
290Same as first, create report and drill down to webpage with own description....
291
292
2934. Verify drilldown to FEX with Parameters-----
294
295create report with lastname, currsal. Drag dept to filterpane and save report2..
296
297Create 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.
298
299so, we pass parameter in drilldown dialog box, send department mis...run.....it will show only lastname, currsal of MIS department...
300
3015. Verify Parameters can be edit and delete
302
303Edit drilldown dialog parameter and remove...
304
3056. Verify Chart with Multi Drill and Auto Drill using wf_retail_lite
306
307Same as autodrill - 2 question...
308
309
310
311REPORT MODE:
312
3131. Verify Theme from Legacy Templates
314
315Create rpeort and click theme. then apply theme from legacy templates.
316
3172. Verify new Theme from Templates
318
319Create report and click theme. then apply theme dark.sty from templates.
320
3213. Verify adding styling to report
322
323Create report and apply style like fontcolour, bgcolour....
324
3254.Verify adding column total and row total to report
326
327Create Report and select col total and row total...Run and check...
328
3295. Verify report with TOC (Table of Contents)
330
331Create Report and select format->TOC
332
3336. Verify report with Pages on Demand
334
335Create Report with more rows and select format->Pages on Demand
336Run will show report in pagetool (Page1)... ill navigate to any page.....
337
3387. Verify report with Title Popup, Accordion, Repeat Sort Value, Stack Measures
339
340Create report and select format -> titlepopup. If we hover prodcat it will show prodcat..
341
342format -> Accordion.... It will show subcat with plus sign....
343format -> repeat Sort values....It will show coffee category for all three subcategories...
344format - > Stack measure Row header will be given for all rows...
345
3468. Verify Preview and Run Time Record Limit
347
348Slicer -> record (Preview limit -10) and runtime limit - 15) in preview it ill show 10 and in run mode it ill show 15 records....
349
3509. Change Report Margins
351
352Layout -> Margin (1.00 inch all round). Run. margin set for all fourside in repoprt...
353
35410. Verify style Report with background color, font color, font size, justification
355
356Home->Style...Change the styles and run...
357
35811. WITHIN report and aggregation
359
360Select cost field and click aggregation (Under display) by country...Run...it will show total of country in all rows which comes under particular country....
361
36212. Report with Page Break, Line Break, Subtotal, Sub Header and Footer
363
364Select field and apply all styles....
365
36613. Verify Excel Formula request
367
368Select excel formula output.. Ill give excel download file...
369
370Logout and reopen and verify excel formula xlsx is checked
371
37214. Verify Sample Data
373
374Select use simple data..it will show simple data...
375Then data from source...It will show data from master data..
376
377
37815. Verify Query view
379
380Drag product from by to filter... logout and check query.., It should show prodcat in filterpane and also in query pane... same ...
381
382
383
384DOCUMENT MODE:
385
3861. Verify activating Document mode from Home Tab
387
388Create report and convert to document and verify. Select pdf output format...
389
390Logout and check report... Pdf choosed and document mode enabled...
391
3922.
393
394
395
396
397
398
399
400OUTPUT FORMAT: (1-3)
401
402Verify all format available. And choosing format giving output....
403
404Logout and check whether selected format is enabled...
405
406
407
408CHART MODE:
409
4101. Verify Chart to Report Conversion-----
411
412create chart and convert to report by clicking report... we can switch report and chart in switch report menu...
413
4142. Verify Hold with Chart mode----
415
416Create chart and check file(is disabled). if we change output format html, it ill be enabled...Click and save..
417
418Run will show ERROR..
419
4203. Verify promoting Chart to Document mode
421
422Create Chart and convert to document by clicking document...
423
424Check switch report..ill show chart1 and document1...move to doc1 and save....close...unsave chart1...
425
426logout and check for doc1...
427
428
4294. Verify InfoMini with Chart mode
430
431
432Create chart and select infomini and select resource/field tab and series tab...save and run....
433
434output shown in infomini toolbar....
435
436We add field and add filter in infomini.. run and save.....
437
438
4395. Verify restore Compute field in Chart mode
440
441we did compute for report in compute ques... Same followed for chart....
442
443
4446. Save and restore Chart: Choropleth Map
445
446Click choropleth map and drag country to layer... Country becomes blue...
447
448Drag continent to color layer... Continent becomes color.....
449
450
451FIELD OPTIONS:
452
4531. Verify Sorting on Dimension and Measure
454
455Drag product to query pane(Across container) and select field-> down.. It show product in descending order...
456
457Drag costgoods to query pane(sum container) and select field-> down... it will show cost of good for all product from high amt to low...
458
4592. Verify hiding visibility (NOPRINT) on Dimension and Measure
460
461Drag prod.cat to (By Cont.) Drag cost of goods, Gross prof to (Sum cont.) Drag Sale,year to (ACROSS cont.)
462
463Click field in querypane.. And hide any u want.... It wont show whole field(With data)....
464
4653. Verify Rank field option
466
467Create report and select field and click field-> Rank.. It will assign rank for field..(1,2,3,)
468
469Delete one field and check....
470
4714. Verify Changing the field Title
472
473Create report and right click field in query pane and change title....
474
4755. Verify Aggregation Function
476
477Select Field and Click Field-> Aggregration-> Average....It ill show avg.Costofgoods..
478
479Click Field-> Aggregration-> Percent....It ill show PCT.Costofgoods..
480
4816. Multiple Traffic Lights conditions using "New" option and styling for each condition
482
483Select field field-> Traffic lights... Enter value and asssign style for that particular value...
484
485Add style for second value by clicking "new" repeat same process..
486
4877. Verify deleting Traffic Lights condition
488
489Select field field-> Traffic lights. Select the Field and delete in Traffic light dialog box....
490
491
492
493
494
495
4968202:
497
4981. Verify SET commands default settings, syntax, save and restore:
499
500Click procedure Settings and source code and verify
501
502Changes Procedure setting values and add fields in report and save
503
504Logout and reopen. verify procedure settings (Equals changed values)
505
506
5072. Verify SET command for Missing Value with Join in request
508
509Data-> Join(Training - md) create report (4 Fields)
510
511Set Missing value as none and verify live preview
512
513Save and logout. Then open and verify procedure (It should show missing value as none)
514
515
5163. Verify SET commands are carried over when promoting Report to Document mode
517
518Create Report and change procedure settings value(Noval for missing value)
519
520Click home -> Document (Report changed to document)
521
522Run and save. Logout.
523
524Reopen saved document and verify procedure setting values(It should be noval for missing values)
525
526
5274. Verify SET Command for Missing Value with multiple queries
528
529Create Report and change procedure settings value(N/A for missing value)
530
531Select new->Build a chart -> Carolap(md)
532
533Select report1 from status bar and save.Logout.
534
535Reopen saved document and verify procedure setting values(It should be noval for missing values)
536
537
5385. Verify SET Command for Decimal Notation
539
540Create Report and change procedure settings value(On for Decimal notation)
541
542Run and save.
543
544Reopen and click chart and check Decimal notation value( It shouldn't be clicked - not carried over(after save))
545
546save chart and verify
547
548
549
550CURRENCY OPTIONS:
551
5521. Verify Currency Formats displayed in the Field Tab ribbon, Define and Compute dialogs
553
554Select any measure field and verify currency options.... after enabling define and verify...like same for compute...
555
556
5572. Verify Currency Formats selection is reflected in the Field Tab drop menu
558
559Select field and change Format option from decimal to euro and verify...
560
5613. Verify Currency Options with SET CDN=ON
562
563Select measure field and change currency to euro..it will be with 2 decimal point...
564
565Click procedure setting and check off decimalnotation - on and run... It will show dot instead of comma and comma instead of dot....
566
5674. Verify multiple Currency Formats in Document Mode
568
569Create document and select euro. Then insert-> report doubleclick 2 fields and set current floating japanese yen...
570
571Then insert-> page. Doubleclick 2 fields and create create page2 document.. Run and navigate to page2 and verify....
572
5735.
574
575
576HOLD:
577
5781. Verify hold JSON format in Report mode
579
580Create Hold file and save as JSon format. and save report.
581
582Create report(from bottom menu)(2 fields) from that hold file(4 fields) and save.
583
584Reopen and verify. It show only 2 fields and in data pana only 4 fields...
585
5862. Verify hold JSON with Chart conversion ***CHART from bottom menu***
587
588Create Hold file and save as JSon format in foccache folder.
589
590create chart(from bottom menu)(2 fields) from that hold file(4 fields) and save.
591
592Reopen and verify. It show only 2 fields and in data pane only 4 fields...
593
5943. Veify hold JSON format in Document mode ***DOCUMENT from bottom menu***
595
596Create Hold file and save as JSon format in foccache folder.
597
598create Document(from bottom menu)(2 fields) from that hold file(4 fields) and save.
599
600Reopen and verify. It show only 2 fields and in data pane only 4 fields...
601
602
603
604DEFINE:
605
6061. Verify field Titles in the Define dialog-----**** whats the use of changing format? What is the use of use field titles enabled?
607
608Create report and select Define.In define dialog box, verify usefieldtitle is selected by default..
609
610Double-Click field and verify data pane withj defin_1 exists...
611
6122. Verify the expected qualified NAME is displayed while setting is "Use field titles" and MFD does not have titles
613
614Create report(sales) and select Define.In define dialog box, verify usefieldtitle is selected by default..
615
616Double-click country and ok. Then doubleclick define_1 from datapane and verify report....
617
618THUMBNAIL:
619
6201. Verify create and modify thumbnail
621
622Create chart and select Thumbnail and save....Edit properties in domain tree and check thumbnail in (Advanced tab).
623
624Reopen and edit chart and select thumbnail. and check properties...
625
626THEMES:
627
6281.Verify push buttons and split menus in default IA Theme
629
630
631Just check Clicked buttons in ribbon are enabled in blue colour...
632
633Check Dropdown button click show in blue colour...
634
635
636CHART MODE:
637
6381. Verify Hold with Chart mode
639
640Create chart(3 fields)...file is in disabled mode...Change format html5 to html...File is enabled....click file and save....
641
642Reopen and run... It will show error..As we do temp file run...
643
644
645API:
646
6471.API > Launch InfoMini Application
648
649Create report and select Infomini...
650
651Reopen and run.. It will open infomini
652
653
654
655INTEGRATE API
656
6571. API > BIP > Launch IA
658
659BIP Tools n
660
661
662
663COMPUTE:
664
6651. Verify field Titles in the Compute dialog
666
667Create report and select Compute.In define dialog box, verify usefieldtitle is selected by default..
668
669Double-Click fields and do calculation(cost- revenue) and verify data pane with compute_1 exists...
670
671Reopen and verify compute_1 edit shows(cost- revenue)...
672
6732. Verify PARTITION_REF function---- ***Partition ref query???***
674
675Create report and compute with partition ref query. Then run and verify...
676
6773. Verify PARTITION_AGGR function-----***Partition Aggr query???***similar TRYY
678
679Create report and compute with partition aggr query. Then run and verify...
680
6814. Verify Report with a Compute field----
682
683Create report and select Compute. Select revenue field and add 9999 and cahnge field name new_revenue and ok... run and verify..
684
685Reopen and check Newrevenue_1 edit possible....
686
687
688
689
6908203
691
6921. Verify Sort by dynamic prompt
693
694Create Report and drag sale,date to filter. Right-click sale,date and select filter.
695
696type-> parameter -> dynamic -> desencending.Run... report show dropdown dates in descending order.
697
698save and reopen and change descebnding to ascending and check output.
699
7002. Verify single-select Dynamic Filter using Define from master
701
702
703Same as one - Area in filter and getting report..
704
705
7063. Verify multi-select Dynamic Filter
707
708Drag country to filter and set parameter dynamic and multiselect.
709
710Create report with country and sales.Run.
711
712in output we can select multiple country and run it will show only 2 selected country with sales...
713
714
7154. Error - HAVE TO ASK
716
717
718
719REPORT MODE
720
7211.Verify HFREEZE - SCROLLHEIGHT=AUTO---------
722
723create report selct format-> Freeze...Run....
724
725Ill allow to scroll till last data...Verify source for HFREEZE = ON - SCROLLHEIGHT=AUTO
726
727
7282. Verify download data with output format CSV--------
729
730Create Report and select Excel(CSV) format.
731
732Run ...It will download cav report open and verify...
733
7343. Verify new Accordion Report--------
735
736Create port and select format-> Accordion..
737
738Run and verify output and source code Expandable on..
739
7404. Verify report with Title Popup, Accordion, Repeat Sort Value, Stack Measures-------
741
742Already DID
743
744
745PREFERENCES:
746
7471. Verify default User Preferences values------------------
748
749Create report and select ia-> Options. verify chart output type formats are available...
750
7512. Verify Global Preferences default values---------------
752
753http://qawin7-03:8080/ibi_apps
754
755Select "Administration" > "Administration Console".Verify options...(File option, chart type, auto drill, home tab, allow user override)
756
757
7583. Verify request with User Selection--------------
759
760http://qawin7-03:8080/ibi_apps
761
762Select "Administration" > "Administration Console"."InfoAssist Properties" > Check off "User Selection" Show checkbox.
763
764Then create Report and run...It will ask output. select active output format and run...Verify getting active output....
765
7664. Verify Global Preferences default values are correct after restoring default values.--------
767http://qawin7-03:8080/ibi_apps
768
769Select "Administration" > "Administration Console"."InfoAssist Properties" > change default chart op format html5 to pdf -> open..
770
771Open Ia and create chart...default op format it ill show PDF....Then, again open and click restore default values...
772
773
774
775SET COMMANDS:
776
7771. Verify SET commands default settings, syntax, save and restore:
778
779Click procedure Settings and source code and verify
780
781Changes Procedure setting values and add fields in report and save
782
783Logout and reopen. verify procedure settings (Equals changed values)
784
785
7862. Verify SET command for Missing Value with Join in request
787
788Data-> Join(Training - md) create report (4 Fields)
789
790Set Missing value as none and verify live preview
791
792Save and logout. Then open and verify procedure (It should show missing value as none)
793
794
7953. Verify SET commands are carried over when promoting Report to Document mode
796
797Create Report and change procedure settings value(Noval for missing value)
798
799Click home -> Document (Report changed to document)
800
801Run and save. Logout.
802
803Reopen saved document and verify procedure setting values(It should be noval for missing values)
804
805
806CONTEXT MENUS:
807
8081.Verify Ribbon menus-----
809
810Slicer -> record (Preview limit -10) and runtime limit - 15) in preview it ill show 10 and in run mode it ill show 15 records....
811
812run dropdown -> Preview. Verify preview op.
813undo action, Hide and show ribbon, Help- verify
814
815
816DEFINES:
817
818
8191. Verify changing order of DEFINE fields
820
821Select data -> Define...Create define_1 -> CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST
822
823Create define_2 -> CAR.BODY.DEALER_COST...Create define_3 -> CAR.BODY.RETAIL_COST.. View source...
824
825Order will be define_1 define_2 define_3... Edit Define_1 -> Define_3 - CAR.BODY.DEALER_COST...
826
827Now check view source -> Order will be define_2 define_3 define_1... add 3 defines and run....
828
8292. Verify Define with Date field type and period separator
830
831data-> define...Double-click sale,date...click format ->date (dmyy) separator -> .Period
832
833Create report with define_1, prod.cat..Run and verify...
834
835COMPUTE:
836
8371. Verify Compute with Date field type and hyphen separator
838
839data-> compute...Double-click hiredate...click format ->date (dmyy) separator -> .hyphen
840
841Create report with compute_1, lastname..Run and verify...
842
843ADAPTIVE:
844
8451. Verify enabling Adaptive Dashboard
846
847Create document and select layout-> Adaptive dashboard...Verify view source arjson...
848
849Reopen and verify....
850
851
852
853
854
8558201:
856
857Document mode
858&
859Below Output format all are remaining.....
860
861
8628202:
863
864Integrating with BI Portal - Doubt....
865
8668203: