SurendraThotaMSBIProfessional

1. ADMIN of CRM online can select this feature to insert  Power BI Tiles in CRM dashboards 2. Go to Seeting --> System -- > Administrration --> system Settings 3. Go to Repoting Tab in system settings 4. Allow Power BI tile embeeding option to Yes 5. Go to Sales --> Dashboards  --> New 6. Select the layout whihc you want to insert 7. Now Click on Power BI Tile Tab ( appears after you perform step 4 ) 8. now you are able to see all the dashboards and tiles you have permission in power BI site 

Step 1 : Create a new web resource in CRM onine ( web resouces is under components is CRM solution) Step 2 :  In new Web Resource give the fallowing details         General          Name : PowerBI_Interactive          Displayname : Power BI CRM Dashboard          Description : CRM Dashboards using power BI     Content           Type : webpage (HTML)           Language : English              URL: iframe code to ccess powerBI reports , by using iframe code you can access power BI reports from any web page where it is used once web resource is created crosscheck if it is listed down in web resources section step 3 : In Dasbords Tab of CRM online  , create a new dashboard and link the web resources created previously Step 4 : save and publish the dashboard

How to Know Actual MDS Table name for Model Entity and Column name for the Attribute . here is the Script  USE MDS ------------------------------------------------------------ -- TODO: Define Model name, Entity name, and Attribute Name        DECLARE @Model NVARCHAR ( 50 )        = '<<GiveModelName>>' ;        DECLARE @Entity_Name NVARCHAR ( 50 ) = '<<GiveEntityName>>' ;        DECLARE @Attribute_Name NVARCHAR ( 50 )= '<<GiveAttributeName>>' ; ------------------------------------------------------------ -- Set @Table name        DECLARE @Table NVARCHAR ( 128 );              SELECT @Table = EntityTable FROM mdm . viw_SYSTEM_SCHEMA_ENTITY WHERE Model_Name = @Model AND name = @Entity_Name ; --...

Hi All when we tried to delete the members whose code is not autogenerated ( ie having specific code to the member) and try to insert the same code member we will get this error. The delete in MDS is a Soft delete which will available in MDS tables even after these deletes . So fallow these steps to avoid the error Step1 : Reverse the transaction of the deleted member to bring the member and its code back to an active state. See here for reactivating a deleted member: https://msdn.microsoft.com/en-us/library/ff487037(v=sql.110).aspx Step 2 : After that , use entity based staging to purge (permanently delete) the code from MDS. This will require using an import type of 4 or 6. Here is more information regarding entity based staging: https://msdn.microsoft.com/en-us/library/ee633854(v=sql.110).aspx Step 3:  Insert the member with same code now you wont get error .

Hi All we need to Create index on some of the Matching attributes in our Customer Entity. It is not straight forward in MDS DB , so for that we need to do the fallowing steps Step1 : Get the Entity ID and EntityTable metadata from mdmtblEntity  table in MDS DB Step2 : Need to Get the attribute tablecolumn from mdm.tblAttribute table . we can create a Dynamic query to create custome index when you know EntityName and attributes names. Dyanmic query USE MDS GO Declare @SQL Varchar(2000), @f int =0 Declare  @i int, @S Varchar(50) Select @S=EntityTable , @i=ID From mdm.tblentity where name='Customer' If Exists (Select Name From Sysindexes Where Name='IX_Customer_MatchAttributes_001') Begin Set @SQL ='Drop Index IX_Customer_MatchAttributes_001 on mdm.' +  @S exec  (@SQL) set @f=1 End Set @SQL   ='CREATE NONCLUSTERED INDEX IX_Customer_MatchAttributes_001 ON [mdm].' Set @SQL= @SQL + '['+  @S +'] (' Select @SQL = @SQL + '[...

Hi All I have listed out some of the differences between azure SQL Database and SQL server Databases. you need to select any one of the 2 based on the features you want in your project , in our project we are handling with PII data where we need Transparent Data encryption which is not available in Azure SQL Database so we went for SQL server databases .   SQL Server Database Azure SQL Database services Category       Size Limitations SQL server can grow upto 524,272 Terabytes 1 to 5 GB for web edition   and    10 to 150GB   for business edition       Connecion Limitations   Tcp/ip   , sharedmemory , and Named Pipes client protocols Only one TCP/IP   Windows authentication No windows authentication   only through username and password   Communication through static/Dyanic port only through 1433 port Unsupported Features In SQL database   Agent Service    ...

Hi All some times when we run the backup or restore of big databases  it will take time and we need to know the status of that task then please run the below query which will the percentage complete . select   T.text, R.Status, R.Command, DatabaseName = db_name(R.database_id)                  , R.cpu_time, R.total_elapsed_time, R.percent_complete from     sys.dm_exec_requests R                         cross apply sys.dm_exec_sql_text(R.sql_handle) T  

Hi All when we restore the MDS DB from one environment to another Environment and the versions are not same in those  environments  in this we case , after restoration is finished we connect to Master Data services configuration manager and then select the restored DB , it automatically enable Upgrade Database option , then go with that option . once everything is configured , when try to connect using Master data maestro tool we are getting I am getting the fallowing error  The execute permission was denied on the object ‘udpSystemget’ database MDS , schema mdm . Cannot find the object 'tblStgBatch', because it does not exist or you do not have permission. Cannot find the object 'tblUserMemberCount', because it does not exist or you do not have permission. Then I started debugging the issue I ran the MDS configuration manager  also it required upgrade database option and I did it , it is successful , and I am also able to browse MDS APP , there i...

Hi All when we restored the MDS database in sql server and configured the Master data services configuration manager  and all the settings went well . when we try to access the Master data services web service we are able to access the web service but when we click on any feature we are getting the [HttpWebRequest_WebException_RemoteServer] Arguments : NotFound  Debugging resouce strings are unavailable  as shown below then we try to browse the  MDS services http://localhost/MDS/Service/Service.svc we got the fallowing error Server Error in '/MDS_PreProd' Application. Memory gates checking failed because the free memory (5234458624 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element. Description: An...

when we are trying to load huge data using ssis we are getting this error ole has sent a request and is waiting for a reply in ssis. The solution we got is apply delay validation = true on the package level so that you can avoid the above error.

Hi All    when are trying to load Float value into Varchar column the data is load with exponential notation .  which is not good for reporting , so we want represent the number as it is without  e   , so when try to convert that float into Bigint  and then convert into varchar we got the  error.  again tried with decimal(38,0)  still got the below error   Msg 8115, Level 16, State 6, Procedure mdm_GetEndXCustomerDetails, Line 16 Arithmetic overflow error converting float to data type numeric.   Then we have used the STR() function which worked very well   LTRIM ( Str ( mem . [MemberCardNo] , 38 , 0 ))  Hope this will save your time    

Hi All we need to get files from Https location and then extract and load . For this we are using Script transformation AS SOURCE . As the file need some string operations to get columns we used Script transformation in that we used Httpwebrequest  to connect to that URL by passing username and password . The package works fine from BIDS in my local machine but when we deployed in dev server and created SQL job  the job is getting failed at  HTTP url connection level . with the fallowing error Code: 0xC0047062     Source: get chat file list get files [1]     Description: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it Code: 0xC0047038     Source: get chat file list SSIS.Pipeline     Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. ...

I just want to explain one of the issue we faced when we are using SSRS connecting to oracle  and how we solved that issue Issue : we have a report which connects to Oracle DB . the Query in the dataset is running in 9 Secs  in PL/sql developer  but the same query is taking more than 150 secs in SSRS. we are using Oracleclient type provider. Solution: we tried with different providers . we tried with Mirosoft OLEDB provider also but it is also taking same time . what we observed is the query designer is formating the query structure so that it is removing Index hints. even when we use the query hint the SSRS is removing those hints while executing . to solve this issue we did a workaround. there is a work around to keep the index Hints . once you have created the dataset ,later open the same datset in Expression mode which is formated by the query designer and write your query which contains Hints. It is working for me . Ref : https://social.msdn.micros...

we are using webservice task in our ssis package and the package is successful in SSDT . when we created SQL job using that package it is failing with  webserviceTaskException: Service Description cannot be null. to solve the issue 1. we have given access to web service for ssis proxy account  2.we have given access on wsdl file folder  3.we given access to temp folder . Still no luck. So the solution for this . We need to give access to wsdl file also.  

Recently when we are migrating sql server 2008 code into Sql server 2012 we found this error . Msg 402, Level 16, State 1, Line 5 The data types datetime and time are incompatible in the add operator.   we came to know that  we cannot  add (+)  or subtract (-)   datatime and time datatype columns as we do in SQL server 2008 . To perform the same functionality we need to cast the time column to datetime column and then perform your action. Delete LKD from OPS_Schema . Alerting_LatestKPIData LKD inner join OPS_Schema . Alerting_SecheduleConfiguration sc on LKD . KPIName = SC . KPIName WHERE SC . LatestCubeDate > =( LKD . latestDate + cast ( LKD . LatestTime as datetime )) and sc . KPIName not like 'NO_DATA_%'

These are main features we need to consider when we are going for tabular model  against traditional multidimensional model . 1. Actions: Additional tab in Multidimensional Cube designer, which allows few triggers in cube development. Tabular model doesn’t have this feature. 2.Aggregations: Tab in Multidimensional Cube designer, which allows additional aggregations to the cube database. Tabular Model lags in this feature. 3.Custom Assemblies: We can add reference of custom assemblies in Multidimensional Cube but Tabular Model doesn’t have this flexibility. 4.Many to Many Relationships: We have direct option for adding many to many relationships in Dimensions and Facts for Multidimensional Cube design. This is one of the option but in Tabular Model we need to do some DAX manipulation for this implementation else no direct way. 5.Translations: Again a direct option in Multidimensional Cube designer but lack in Tabular Model designer solutions. 6.Data Mining : D...

1.    How to use heterogeneous data sources in SSAS 1.1 Introduction              In our Microsoft BI projects we are creating many SQL Server analysis services CUBEs. In General all the Facts and Dimensions are present in one single SQL server instance which is most common design that everybody will fallow .In some cases we need to get the data from two different instances of SQL servers in this case one instance acts as primary data source and other instance acts as secondary data sources in Data Source view (DSV).   In our Telecom data warehouse we have different applications in different relational databases. Most of the mobile traffic data and Transactional data is available in Oracle and remaining Customer, CDR and Historical data in Teradata databases. We have to create near-real time CUBEs which we need to present /Alert data within 5-10 minutes of actual event occur for example if number of cal...