Data BI Visuals

This post explains you the latest features of SQL Server 2017. Features, 1. Machine Learning - In Database             a. R             b. Python 2. Machine Learning - Standalone Server 3. Standalone Reporting Server Check the other features in below video.

In Simple English, Not is being used to show the negative meaning of the context. In Web Intelligence, "Not"" is also projected as same but still we can use for reverse logic. Syntax of Not Function: Not(Object) – It returns boolean value. For example, consider a below condition. If “Status” = “Approved” then “Process Completed” else “Waiting.” If “Status”<>”Approved” then “Waiting” else “Process Completed.” We can use NOT function for the second condition. It would be like below, If NOT(“Status”=”Approved”) then “Waiting” else “Process Completed.” When we see "Not" function alone, then it would be simple, but when "Not" function is combine with other functions, then we can handle the complex logic very quickly.

Microsoft released SQL Server vNext as a platform for windows and Linux. Check the below video to know the installation process of SQL Server vNext.

This is one of the post from SAP Business Objects Admin collection. It explains the default access levels that administrators can use to assign access to end users. Each Access level is defined with certain set of permissions for all the tools in Business Objects. This can be customized based on your requirement. If you think that you don ’ t want to touch the default access levels, you can create a new access levels with your requirements. Check the permissions that end user get when you assign the access levels. View Access Level It will be the preferred access level who just want to give only read or view access of reports. View on Demand Access Level It is slight advanced than view access level as it has the refresh option where end user can refresh the reports. Schedule Access Level This is just for schedule the reports. This access will be assigned to users who take care of reports schedule. Full Access Level This will provide ful...

Can anybody claim that you are secure in this digital world? Mostly, NO!!! Always someone is watching you when you are using internet. I am not mean that you should be away from internet to get privacy and security. You should know who are all watching you so that you can easily handle them. If you are using Google Search on your day to day activities then google is watching you. The same is applicable for Andriod Phone users as it is a product of google. This post explains that how you can check what are the activities has been monitored by google. Google not just monitoring and recording your text inputs, it is also recording voice & audio. You can track all your voice and audio that has been recorded by google. All the information are maintained in google history page. Check the googlehistory page and look at your recordings The above URL redirects to https://myactivity.google.com/myactivity?restrict=vaa You should sign-in to see your acti...

For each view, system will create a table whether it might be SAP HANA LIVE view or Calculation view or Attribute view. Those tables will be reside in system schema "_SYS_BIC" Expand the schema -> Column Views. There you can see lot of tables. Tables will be available for each view and each column inside that view. Make sure to get the main view. For example if you take HANA Live View "VBAK_COM". --Main View table select top 10 * from "_SYS_BIC"."sap.hba.ecc/VBAK_COM/" To select view with particular column, follow below select top 10 "SalesDocument" from "_SYS_BIC"."sap.hba.ecc/VBAK_COM" The above table can be access in SQL console, it will give the output which is same as what you have seen in the data preview. The other tables also available for columns select top 10 * from "_SYS_BIC"."sap.hba.ecc/VBAK_COM/SalesDocument/hier/SalesDocument" The above table will give deta...

By default, "Object from this query" option will be disabled when drag and drop the object in query filter.     How to enable "Object from this query" option?   It is easy to enable this. As you can see in the filter, by default "In list" option will be there, by changing the value from list to other values , "Object from this query" option will be enabled. 

There are many sites to see the list of Tcodes/ TXN codes . Here I displayed the look and feel of Tcodes. TXN Look and feel SE11 SE12 SE13 SE14 SE15 SE16 SE17 SE18 SE19 SE20 SE37 SE38 Thanks Let me know, if you want the same look and feel for other Tcodes

Google showing dashboard with all Google apps with that status. It will be useful to check before buying mail users for enterprises. From this dashboard, we can able to identify the down time of the apps, when it happened and how long it has been for service disruption mode and service outage. Check the dashboard in below link http://www.google.com/appsstatus#hl=en&v=status

How to customize the table look. We can able to get alternate colour for table like in excel. If you choose pre-defined format, we will get two colours. We can achieve the same in Webi report also. Objective: We are going to see, how to get the table like below As you can see, it used two colour alternatively. We are going to learn, how to get that. Step 1:  Right click on the table and look for “Format table” Step 2:  Go to Appearance section and find alternate colour at the bottom. This is the place we have to select colour and row frequency. Thanks. Please let me know, any more tips or queries on Web Intelligence.

In some situations, we need to compare the original document with the revised one. It will be difficult to check one by one when it has more pages. There are many 3rd party tools are available to compare word documents. But Microsoft itself providing the feature. Have you noticed that in your word document? Mostly NO. Because this feature needs to be added manually from options. Let see how to add this feature in word document. Go to options by clicking the file option in top left corner. Select customize ribbon and choose all commands and find “Compare” Add that feature into customize the ribbon section, under new group. That’s it, you have added compare feature in your document. Check it in Home tab or wherever you added. Start comparing documents. Thanks

In this post, we are going to learn how to create a nested filter in web intelligence rich client. Drag and drop the objects into the query filter like below, You can change the condition to OR by clicking on "AND". Now drag the filter over the filter you wish to nest with. Now am dragging the "Kunnr" filter into "Land1", you will get screen like below, We got the nested filter. It is nothing but the filter over filter. As per the requirement, you can change the condition "And" & "Or". We can check the Query script viewer to confirm the result.

By using query properties, we can restrict the records to display in a report. Please check the options in query properties Max rows retrieved - Maximum number of rows of data that are displayed when a query is run. This is related with Sample Result set. For example, if you give 1000 rows in "Max rows retrieved" then 500 rows in "Sample Result Set" then you will get 500 rows only. Also it can be restricted based on the administrator security profile. Sample Result Set - It determine the Maximum number of queries returns. This restriction is applied in database level. Fixed - At each data refresh, query returns the same rows when Fixed option is marked. If not then on each data refresh, query returns different set of sampled rows Retrieve duplicate rows - In some cases, in database, the same data may be repeated over many rows. You can restrict those data using this option.

One of the tab in WebI report is, Report Element Tables Cell Section chart others Tools, Position & Linking Tables  - We can create variety of tables Vertical Table Horizontal Table Cross Table Form   Cell  - We can add 2 types of cell in report Blank Cell Pre-Defined Cell Section  - Insert section based on the table values Chart  - Different type of charts Others  - Apart from normal default, we have plenty of other charts also available Tools, Position & Linking  - The other tools under report element will be in disable state till we add any of the figure in reporting area. Other elements will be discussed, keep visit here. Thanks

In BO, we need to setup a user selection screen for most of the reports where user feed their input and based on the input value report will display the results. We can get the Prompt option in 2 ways either in IDT or WEBI. Prompt option in IDT, We can create prompt (Dynamic filter) by creating filter in Business layer. If you don’t know where to create filter, check it below. Double click on the filter and go to WHERE area, their you can use @prompt function to achieve the prompt. @Prompt Function Syntax: @Prompt (1, 2, 3, 4, 5) 1=”Prompt Message” (This will show while prompting) 2= Prompt Type (A = Character ; N=Number; D=Date; U=Unit) 3=Class Name/Object Name 4=Multi or Mono (Multi = Multiple (2001,2002, 2003); Mono=single (2001)) 5=Free / Constrain (Free – Select Value from LOV; Constrain – Select Value) Example Value : ."VLCVEHICLE"."MATNR" IN @Prompt('Enter Value','A',{'value1','value2','value...