SSAS


Comments

Post a Comment

Popular posts from this blog

401 Unauthorized access Error in SSRS

In the SSRS Reporting Environment, you may never encounter this error and you live a happy and easy life. We all know an SSRS report can easily ping your server to 100% CPU if you decide to export a 120 page report, to PDF,  with charts, etc. etc. You may get a complaint that performance suffers in another application while running the reports and you want to fix it, but do not know how. Then one day you or someone at your firm has decided to do your SQL Server a favor and separate out SSRS from the SQL Server. This sounds like a great idea. You build a new SSRS box (lets call it SSRSPROD), run some performance optimizations (http://sqlcat.com/technicalnotes/archive/2009/01/14/reporting-services-performance-optimizations.aspx) and you are set. You remote onto the new server, deploy all of your reports, open up IE on your server and check the reports; they run and life is good. You give the all clear to your users and suddenly your inbox is flooded with "My Reports do not work,...
Read more

Migrating SQL Server Reporting Services (SSRS) from a busy server to a dedicated server can provide several benefits

 Migrating SQL Server Reporting Services (SSRS) from a busy server to a dedicated server can provide several benefits, including: Improved performance: When SSRS is running on a busy server that is also hosting other applications, it can cause performance issues for SSRS. Moving SSRS to a dedicated server can improve the performance of reports and reduce the time it takes to generate and deliver them. Scalability: A dedicated SSRS server can be more easily scaled than a busy server that is hosting multiple applications. As your reporting needs grow, you can add more resources to the dedicated server to ensure that it can handle the increased load. Better resource management: By moving SSRS to a dedicated server, you can better manage the resources allocated to reporting. You can configure the server to optimize its performance for SSRS, which can result in more efficient use of resources and faster report generation times. Increased security: By separating SSRS from other applicati...
Read more

Python code to unprotect the excel sheet with a valid password

import msoffcrypto import pathlib # pip install msoffcrypto-tool' url = pathlib.Path(r'D:\Source') excel_files = list(url.glob('*.xlsx')) def unlock(filename, passwd, output_folder):     temp = open(filename, 'rb')     excel = msoffcrypto.OfficeFile(temp)     excel.load_key(passwd)     out_path = pathlib.Path(output_folder)     if not out_path.exists():         out_path.mkdir()     with open(str(out_path/filename.name), 'wb') as f:         excel.decrypt(f)     temp.close() for i in excel_files:     unlock(i, 'Password', r'D:\Destination') ------------------------------ # Replace "C:\Your\Directory\Path" with the actual path to the directory you want to search in. $directoryPath = "D:\Testing" # Replace "2023-06-30" with the date you want to check in "YYYY-MM-DD" format. $targetDate = "2023-06-30" # Get all the *.txt files in the specified directory that match the ...
Read more