fix(schema-compiler): Support member alias for TD with granularity

[mcheshkov]

Check List

• [x] Tests has been run in packages where changes made if available
• [x] Linter has been run for changed code
• [x] Tests for the changes have been added if not covered yet
• [x] Docs have been added / updated if required

Description of Changes Made (if issue reference is not provided)

There's no way for SQL API to specify time dimension in load query during SQL generation for CubeScan: only "dimension" part is supported by Cube ATM, and either SQL API should trim granularity from member path, and replicate alias logic from schema compiler, or schema compiler should support granularity in aliases

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

8 Skipped Deployments

| Name | Status | Preview | Comments | Updated (UTC) | | :--- | :----- | :------ | :------- | :------ | | **examples-angular-dashboard** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-angular-dashboard/9ByP6QHH2v6H3rFXnKRLKViYFyzB)) | [Visit Preview](https://examples-angular-dashboard-git-member-alias-wit-ea1608-cube-dev.vercel.app) | | Nov 13, 2024 0:05am | | **examples-react-d3** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-d3/514Q3rp2yNr3iGc6NcTA3qYwTu5W)) | [Visit Preview](https://examples-react-d3-git-member-alias-with-granularity-cube-dev.vercel.app) | | Nov 13, 2024 0:05am | | **examples-react-dashboard** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-dashboard/GGmZRw9rvJ7CmGTASjVsALCUSZ6X)) | [Visit Preview](https://examples-react-dashboard-git-member-alias-with-853179-cube-dev.vercel.app) | | Nov 13, 2024 0:05am | | **examples-react-data-table** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-data-table/GNhTurUnLWjfN7Nhk4QSPC6jTw8N)) | [Visit Preview](https://examples-react-data-table-git-member-alias-with-102d87-cube-dev.vercel.app) | | Nov 13, 2024 0:05am | | **examples-react-highcharts** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-highcharts/HPmv1wpUy9dVMmxdGm1VM1kSgeVb)) | [Visit Preview](https://examples-react-highcharts-git-member-alias-with-36a037-cube-dev.vercel.app) | | Nov 13, 2024 0:05am | | **examples-react-material-ui** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-material-ui/8RWYZxnEgQhftmguu4eG5e8ScRfM)) | [Visit Preview](https://examples-react-material-ui-git-member-alias-wit-4b9a11-cube-dev.vercel.app) | | Nov 13, 2024 0:05am | | **examples-react-pivot-table** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-pivot-table/Cdh49D61wiLz8iDXr7we1Xcjpkw5)) | [Visit Preview](https://examples-react-pivot-table-git-member-alias-wit-e9247b-cube-dev.vercel.app) | | Nov 13, 2024 0:05am | | **examples-vue-query-builder** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-vue-query-builder/8YWQ6wa4icHY8qVDxbMj57GHTpAS)) | [Visit Preview](https://examples-vue-query-builder-git-member-alias-wit-afa815-cube-dev.vercel.app) | | Nov 13, 2024 0:05am |