Category Archives: Quick Fix

Retrieving id of inserted record: What to use @@IDENTITY or SCOPE_IDENTITY() or OUTPUT

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, This seems very basic information but need to know properly. Issue: I need to find out or have the id of the records which I inserted in table. Analysis: This requirement seems very simple but there could be various cases where you would not get the correct id just by using @@IDENTITY function. Think of the case where you are inserting a record in table A and there is a trigger which fires as soon as there is a insert in table A which insert a record in table B. so in such case @@IDENTITY wont give you the … Continue reading →

The Story of Precision, Scale, and Length in SQL Server

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, Did you ever faced issues with BIG mathematical figures – related to either overflow or any  other arithmetic errors. This may be applicable to SQL arithmetic operations or arithmetic  operations you do with SQL table in SSIS etc. Well, check 1 more time, if you have any issues in your database design related to column  data type which stores the BIG numbers. I ran into this issue couple of times, and reason behind this issue was same all the time. So  decided to do a quick post. And that reason is “Improper or insufficient precision, scale and length defined for storing … Continue reading →

Tracking Down Ghost Characters: WHERE Clause Does Not Work Properly In T-SQL Query

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, I would like to share an experience with you when I was working on 1 SSIS related issue. Scenario was: I have to exclude some records from Table A by matching some keys of Table B.  Table A Year Month CustomerCode <Extra Columns> 2012 JAN CX1000   2012 JAN CX2000   2012 JAN CD3000      Table B Year Month RecCustomerCode <Extra Columns> 2012 JAN CX1000   2012 JAN CX7000   2012 JAN CD8000      What is expected was – Table A’s following records: Year Month CustomerCode <Extra Columns> 2012 JAN CX2000   2012 JAN CD3000   … Continue reading →

Microsoft SSAS Solution: Cube Design Considerations

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, today i read James Serra’ post – whether 1 single BIG cube is good as comapred to multiple small cubes. Check out the advantages and disadvantages with both design approaches. he made a pretty nifty list of both of these. i would also recommend you to read this post. here is the link: http://www.jamesserra.com/archive/2013/01/ssas-one-giant-cube-or-many-small-ones i hope you also find this interesting. thanks, khilit

Continue reading →

User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, its seems like this issue have been faced by many prople. i have checked the solutions on web and found that not all answers contains the complete solution. so decided to put 1 complete solution here. in most of the places, you will find answers like… Run IE as Administrator -> Open Report Manager site -> Add your user in “System Role Assignment” (settings) etc. But there is tini-tiny step you have to do before you run your IE as Administrator. Open your IE -> Tool -> Internet Options. Security tab -> Local intranet -> Sites -> Advanced … Continue reading →

SSRS Chart – Displaying % sign on Y axis + Displaying % sign on Data Labels

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, Today i would like to show you the little trick for your SSRS graphs. Issue: I am displaying values (percentage values) in my bar charts as “Data Labels”. But the “Y” axis of my bar char still displays value without the “%” sign. What I need: The bar chart should display the “%” value in Data Labels as well as on my Y axis. Simple try: When you format the Data Label to apply “%” sign by making it of type “Percentage” in “Series Label Properties” -> “Number” -> “Percentage”. It actually multiply the value by 100 and … Continue reading →

View is not showing newly added column in table

Khilitchandra's Business Intelligence Blog Posted on by

Hi all, This is for the people who still use “Select * From Table” in their SQL Views. I don’t know what is the reason that you are using this way to create your views, but you could be the victim of this scenario (see… what title says). Let me show you how you can solve this issue… in-case you come across one. When this happens?? You make changes in table which is the source of your view. Changes like modifying existing column definition, adding new columns or removing existing columns from table could cause this issue. Where can I … Continue reading →

SSRS Report is asking for Username and Password while executing

Khilitchandra's Business Intelligence Blog Posted on by

Hi all, I want to bring to your focus a very minor detail which could eat-up your time when it happens. This is the case when your SSRS report is deployed on ReportServer and you are accessing thru any application or interface e.g. SharePoint. Your SSRS report is using Integrated Security and hence no need to provide Username and Password if you have access to the Report. And everything works fine up to this point. After some days, if you notice that your SSRS Report is not working as expected and it has started asking for Username and Password while … Continue reading →

Quick-Fix: Report parameter with space in SSRS

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, One of the most common practices and a wise recommendation is to display selected report parameter(s) in report … may be in header or body of SSRS report. It’s a good reference when you export the SSRS report into available formats (Excel, PDF, Word etc.) Because if you don’t include/show selected parameter(s) in exported report then it becomes less-meaningful for a person who is reading/using the report … probably for some decision making.

Continue reading →