olap | 睿思BI-OLAP开源多维分析系统 | Business library
kandi X-RAY | olap Summary
kandi X-RAY | olap Summary
睿思BI-OLAP开源多维分析系统
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of olap
olap Key Features
olap Examples and Code Snippets
Community Discussions
Trending Discussions on olap
QUESTION
is there a way to bind 2 OLAP Cubes with the same structure into one? As for now I have big Datasets for past 10 years (20-50 milion records each cube) that is every day processed. For optimalization purposes I want to separate it. For exaple the data for past 8 years will be processed once and the new data will process daily. For it it would need 2 Cubes but can I merge results from it?
Edit. Im reading on blogs and forums about partitioning the data but how does it really work? Would I be able to process only the new data so I dont need to process all 30+ mil rows?
...ANSWER
Answered 2021-Jun-11 at 16:08Processing these partitions is done separately from the cube design. One way to deal with this is by scripting out the commands and running them in a sql agent job:
1- Connect to the ssas instance, browse to the dimensions folder and hit F7 to open the object explorer details window.
2- Highlight all the dimensions, right click and select process
3- In the dialogue, select the script button and choose script action to new query window or script action to clipboard and save it someplace. This will be the xmla command to update all the dimensions.
4- Next, navigate to the measure group in which you made the partitions and select the last partition in the group which you want to refresh daily. Right click, select process and use the script option to create an xmla command
5- Next, select the measure group folder and select all the measure groups in the object explorer detail window, except for the partitioned group. Right click, select process and script out the command as in step 3.
6- Now that you have all the commands, add them to a SQL Agent job with 3 xmla command steps, one to process the dimensions and the next two to process the measure groups and most recent partition. Note that if this is running under the sql agent service account, that account will need to have permissions to process the cube.
tip add another job to run on the weekends which does a process full over the whole cube. This is a little cleanup step to make sure everything stays in sync.
QUESTION
AWS recently introduced S3 Object Lambda, however looking at the online documentation:
- Writing and debugging Lambda functions for S3 Object Lambda Access Points
- Introducing Amazon S3 Object Lambda – Use Your Code to Process Data as It Is Being Retrieved from S3
- How to use Amazon S3 Object Lambda to generate thumbnails
I can only find example for Java, Python and NodeJS.
Is there an example out there for c++ that I missed ? In particular I fail to understand what is the equivalent in c++ for getObjectContext (python/nodejs) / S3ObjectLambdaEvent (java) ? How should I retrieve outputRoute, outputToken, inputS3Url ? The integration test does not make it particularly clear either:
ANSWER
Answered 2021-May-25 at 18:25S3 Object Lambda is using the AWS Lambda service. AWS Lambda does only support the following runtimes "natively":
- Go
- .NET Core
- Ruby
- Java
- Python
- NodeJS
C++ is support through "custom" runtimes or through Docker containers. Usually, the AWS documentation only covers the "natively" supported runtimes and even then not all (as you noticed). Mostly they have examples for the most popular ones.
So what you need to look for are C++ Lambda examples, examples using the C++ AWS SDK and reference documentation.
Using the reference documentation and the Java/Python/NodeJS examples, it should be easy to write a C++ version.
For example:
QUESTION
Our setup is SQL Server + SSAS + multidimensional OLAP + PowerBI on top of it.
Recent issue we noticed is that when user loads PowerBI report, from time to time forementioned event occurs. This leads to really long waiting time until the report loads (event takes up to 45-60 seconds).
Our cube has ~20 dimensions and ~50 measures, 2-3 million rows in 3 partitions, MOLAP storage.
What can we do about it? How can we debug it? We don't have SSAS experts on board and googling this event didn't help much. Where can we search for reasons of such behavior?
...ANSWER
Answered 2021-May-12 at 09:59It turns out that in our case it was probably caused by cache being dropped each time the cube was processed.
Our solution would be creating SSIS Package that would run certain DMV queries to populate cache every time we process our cubes, so end-users would be able to use the cache instead of generating it themself.
QUESTION
I was of the impression that in OLAP , we try to store data in a denormalized fashion to reduce the number of joins and make query processing faster. Normalization that avoids data redundancy was more for OLTP systems.
But then again, 2 of the common modelling approaches (star and snowflake schema) are essentially normalized schemas.
Can you help me connect the dots?
ANSWER
Answered 2021-May-11 at 17:47When people use the term "normalised" they normally mean something that is in, or at least close to, 3rd normal form (3NF).
Unless you mean something significantly different by the term normalised then neither Star or Snowflake schemas are normalised. Why do you think they are normalised?
QUESTION
My question might be little native. What is the meaning of transaction in OLTP? Is it same as ACID Transaction or there is something else?
NoSql database like cassandra doesn't follow ACID properties. They follow CAP. In which category Cassandra falls? Is it OLAP or OLTP?
...ANSWER
Answered 2021-Apr-30 at 08:16In those context, they both mean database transaction.
OLTP emphasizes that it's a transactional system and usually came with better transaction supports such as ACID.
QUESTION
We have been using simple date warehouse for banking, that loads bulk data every night while the system is off, and connected to Obiee via Administration tool. It is working fine till now.
Recently, we have been discussing about moving to OLAP for our Data Warehouse since by definition it seems OLAP is most suitable for data retrieving even though it requeires one more step to develop dimensions and measure facts in Analytics Workspace. And some sources say that queiries will take more time to return results when OLAP is used. If there are some developers who switched from usual dwh development to implementing OLAP in it, do you recommend it?
...ANSWER
Answered 2021-Apr-20 at 09:31To put it simply: If the data source configuration and model are rubbish, then it doesn't matter at all if you go for a dimensional model. I've seen flat-table-based models which performed like crazy and "OLAP models" which were slow beyond believe. Nothing is a fix-it-all solution. Never believe that slapping a new badge on something will solve a problem. You need to think about it and architect properly and accordingly.
QUESTION
This is the address that contains the data I am looking to convert into a dataframe: https://oec.world/olap-proxy/data?cube=trade_i_baci_a_92&Exporter+Country=nausa&HS4=42204&Year=2016&drilldowns=Importer+Country&locale=en&measures=Trade+Value&parents=true&sparse=false&properties=Importer+Country+ISO+3&q=Trade%20Value
I want the headers to be Continent ID, Continent, Country ID, Country and so on. How do i go about it?
...ANSWER
Answered 2021-Apr-16 at 11:43requests and pandas json_normalize do the trick:
QUESTION
I'm trying to execute an OLAP traversal on a query that needs to check if a vertex has a neighbour of certain type. i keep getting
Local traversals may not traverse past the local star-graph on GraphComputer
my query looks something like:
...ANSWER
Answered 2021-Apr-08 at 14:40That is limitation of TinkerPop OLAP GraphComputer. It operate on 'star-graph' objects. The vertex and connected edges only. It uses message passing engine inside. So you have to rewrite you query.
Option 1: start from label2 and go t label1. This should return the same result
QUESTION
My task is to make "OLAP cube", aggregated by time intervals
So, it is supposed, that facts table will store aggregates:
- for each day
- for each month based on its days records
- for each year based on its months records
And it will look like this:
...ANSWER
Answered 2021-Apr-07 at 16:38It is not good idea, in most cases, to mix facts of differing granularity in a single fact table. If you really need to store daily, monthly and yearly data, consider more than one fact table.
You can also have a dimension table with one row per day and various attributes that facilitate aggregation, such as fiscal year.
QUESTION
I have access to our database through an OLAP pivottable. I often want to filter based on multiple client numbers (which are not continuous). The client list is so long, however, that trying to scroll through and manually select clients is out of the question. I am hoping to solve the issue by adding a slicer and using a macro to select visible slicer items (though I'm open to other ideas). I'm hoping to have a worksheet where I can add a list of client numbers I would like to filter on which the macro applies to the slicer when run.
When I recorded a macro, it produced the following code:
...ANSWER
Answered 2021-Apr-05 at 21:42The Array function takes a list of values and turns them into an array. Using Array(s_array) gives you a one-element array where that one element is itself an array that has (s_count - 1) elements - i.e. from zero to (scount - 2). In other words, you have created a two-dimensional array with bounds (0 To 0, 0 To s_count - 2).
To solve this, just use s_array directly and leave out the Array(...) part:
wb.SlicerCaches("Slicer_Client_ID").VisibleSlicerItemsList = s_array
Note: answer assumes that the default Option Base 0 is in effect and that arrays start with element 0
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
Install olap
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page
