In the BigQuery documentation it is mentioned that it uses OLAP functions. But the developer documentation does not mention MDX query language, dimension or fact tables. What OLAP features, if any, are in BQ and how are they
BigQuery is not a traditional OLAP system. The similarity to OLAP is in its ability to rapidly answer multi-dimensional queries. There are no cubes or star/snowflake schema that one might find in a traditional OLAP system. Instead BigQuery excels at ad hoc queries, usually over a large flattened table. If you can share your use case, others on this forum may be able to suggest some best practices to accomplish your goal using BigQuery.
I am agreeing with Andrew. No OLAP process, no MDX or similar, just sql and no integration in google spreadsheet ! I don't think that business users will use big query as an olap system, let's say that it is a cloud access like DB, that is good
