Data BI Visuals

This topic will be familiar to everyone but still i have some ideas that how can you make your google search in a effective way. The usual way of searching a topic in google would be simply typing the keywords that we want to search. Yes it will give you the results but do you think those results are expected (satisfied) results? There many ways to search content in google, for example we can search the keywords with in the double quotes, it make google search engine to look for specific word. Again, will you get expected (satisfied) results? First of all, understand how the contents are available in internet. It is because of someone writing (sharing) information to us, it could be a company or individuals. When you search in google, it may list out the results number of pages. for example, you are getting around 3 pages of information. Does it mean only around 30 websites are having information that you search? Not really!. There are lot and lot of websites has your informat...

Usually, when we add few values in excel row and we will get an option to drag until to the end. The values are automatically inserted into the cells. In latest version of office releases, this option is disabled by default so we won't a see an option for drag and drop. To enable this option in excel, follow the below steps. 1. Go to Options in Excel. 2. Choose "Advanced" section. 3. Look for a check box "Enable fill handle and cell drag-and-drop" and select the check box. 4. Click ok and you can see a fill handle. Screenshots,

Partitioning a table is an easy step to get a performance, it has been introduced in SQL Server 2005. Partitioning is nothing but we are splitting the big size records into small pieces. For example, we have a table called “Sales” which is having more than 100000 records, to query this table will take time, so to improve the performance we split the table like 25000 records in one piece and from 25000 to 49999 to another piece likewise for all the records. FYI, we will not get multiple table names since it is partitioned, the same table stored the records into multiple pieces. Steps to create partitioned table. Check the below scripts to create your own partitioned tables. Step 1: --Create Partition function with a range of values CREATE   PARTITION   FUNCTION  Prt_table   ( INT )   AS   RANGE   LEFT   FOR   VALUES ( 25000 , 50000 , 75000 , 100000 ) GO Step 2: Map the file group for the range of values. --Create p...

We can create two types of databases in SQL Server 2014, the first one is normal database which is common in all versions of SQL server and the other one is memory optimized database. Database creation script is differentiated only by adding few lines on the normal script. Script for Normal Database creation – AdventureWorks2012 CREATE   DATABASE  [AdventureWorks2012]  CONTAINMENT  =   NONE   ON    PRIMARY (  NAME  =   N'AdventureWorks2012_Data' ,   FILENAME   =   N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Data.mdf'   ,  SIZE  =  209920KB  ,  MAXSIZE  =   UNLIMITED ,  FILEGROWTH  =  16384KB  )   LOG   ON (  NAME  =   N'AdventureWorks2012_Log' ,   FILENAME   =   N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_...

We have following access as default in SAP Business Objects. View View on Demand Schedule Full Full (Owner) If you have any custom requirement on access then still we have option to create new access level. Check out the access levels in CMC,

Here is the collection of videos to learn Web Intelligence Report in SAP BO Real Time Scenario in Webi - Advanced scenario in Webi, https://youtu.be/1pMI12iYb-E SAP BO Query Properties - https://youtu.be/5qjd8kbYbHc WEBI Element Link - https://youtu.be/b_D_PAI4N_Q & https://youtu.be/zTfbnQi70I4 Pre-Defined Webi Expressions - https://youtu.be/3gGxhQd4TcE & https://youtu.be/qsooNc1ub2I Webi Report Change source - https://youtu.be/RgEyJVgMnvI Webi Input Control - https://youtu.be/Gpf3AIpLkRM Conditional Formating in webi - https://youtu.be/ogIW5xkbQJw Webi Aggregate Functions - https://youtu.be/LV-ZvndKc_E WebI - Break & Subtoatal - https://youtu.be/r39C3BrCC-U FREE hand SQL Data source in Web Intelligence | SAP BO | Advanced - https://youtu.be/UJ0JOqf5vpY FREE hand SQL Data source in Web Intelligence | SAP BO | Basic - https://youtu.be/ueUJhY-XB3w Business Layer View in Universe | SAP BO - https://youtu.be/SRGXtlN_EOk #MULTIVALUE Error in Web Intelligence Report...

Hi All, welcome to everyone to my site. You are going to get more technical stuff from below technologies, SQL Server SAP HANA SAP Business Objetcs SAP BW Thanks