microsoft / microsoft/sql-server-samples

SSAS project giving errors

Open
#627 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
PowerShell
Stars
11.2k
Forks
9.1k
Avg merge
2d 7h
Merged PRs (30d)
14

Description

SSAS project when run is giving many errors. Also the DW DB .bak file has old dimension date table.

What I am looking for?
A running project of SSIS and SSAS along with the correct fields in DW.

SSAS is giving errors of Invalid column name. Date Key related issues.

Does anyone have a working SSAS project?
Does anyone have the latest DW .bak file?

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reviewing the SSIS and SSAS project together with the DW .bak file, focusing on the outdated dimension date table and the reported invalid column name and Date Key errors. Done means the project runs and the DW contains the correct fields, including the expected date-related fields.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
data, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.