The creation of Cuba OLAP
The base contains a table with goods information, a table of goods sales for the period, a table of movement for residues and revenue for goods for the period, as well as a table with calculation indicators
It is necessary to set the analytical OLAP cubes to perform the rapid viewing and analysis of the information contained in the base through the Excel/interface.
You also need to use SQL requests to set the calculation of key efficiency indicators (KPIs)
Client's review of cooperation with Dmitry Vasiliev
The creation of Cuba OLAPDmitry is a great specialist. I expect long-term cooperation. I recommend to everyone
Freelancer's review of cooperation with Aleksey Tkachenko
The creation of Cuba OLAPA great project!
Great customer, always in contact, all questions quickly closed!
I recommend to everyone!
-
298 5 0 Hello to you.
We create an OLAP cube in SQL Server Analysis Services using both multidimensional and tabular models.
I will correctly adjust the work with semi-additive measures, in your case the remains.
I adjust the units, optimize the speed.
If necessary, help to set sections, the data update mechanics using proactive caching.
To work with the cub will use Excel (visually as a summary table), it is possible to adjust roles and prospects.
with respect,
Dmitry
-
318 Interestingly, I am mainly engaged in 1C since 1999, there are periods of the need to form direct SQL requests to different bases...
On Excel-vBasic I wrote in VUZAHs...
Enter the base type to verify the ability to connect with Excel
The number of OLAP cubes, the list of KPIs - for the formation of budget/frames
-
250 37 1 2 Write to Ls we will discuss.
There are a few questions.
OLAP cubes - we can set the pipes.
Current freelance projects in the category Databases & SQL
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 2 hours 51 minutes back ∙ 4 proposals |
It is necessary to upload products into the corresponding categories and subcategories from SQL files.The site is created on WP. It has a product catalog. Products were uploaded from a PDF file, resulting in a bit of a mess. There are three files with a clear distribution of categories, subcategories, and products in them. In the file PA.sql, categories are numbered, for… Databases & SQL, Web Programming ∙ 6 hours 22 minutes back ∙ 28 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 14 hours 57 minutes back ∙ 33 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 3 days 9 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
602 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 5 days 13 hours back ∙ 56 proposals |