Can't comment on stuff under nda but agree that a lot of folks are having trouble keeping up with the faster release cycle.

@jeff - I'm a huge fan but the question had definitely been answered 3+ years ago :hehe:

@snap - fully agree that nothing you'd said was untrue re: proclarity. And...

you revived a thread that's almost 4 years old? and not to add value but to advertise? not good karma, a HDD crash in your future I see.....

Not...

Actually, on re-reading, can you open SSMS in the context of the service account user. Connect to the SSAS instance and then right click, select Properties. Nav to...

Can you post an image of the error or the error message?

Would you not have the dollar items (price, cost) as...

I was thinking more of the equivalent of "distinct count(License_ID)" ie a new, single measure that counts the distinct license instances. I can see that working when you're looking...

distinct count, tied to the license ID?

Ok, so I definitely misunderstood :hehe:

I'm not sure what the issue is that you're expecting? You can definitely use a License dimension to relate the two fact tables. Is...

I may be misunderstanding the situation, but if the sale event is at the grain of 'count of licenses' but the action fact is at the license instance grain, then...

Possibly? :hehe:

I guess based on what you've supplied below, I would say more like

Flat File

|

Derived Column

|

Data Conversion

|

Temp/Perm "work" table [SQL Server Destination]

|-------------------------|

| Execute SQL task

| ...

Have you tried AGGREGATE instead of SUM?

Depending on your version of SQL (e.g. using 2008 R2, i think also 2008) you could use the MERGE statement, which is the SQL equivalent of an Oracle UPSERT (ie...

No offence to BitBucket, but the TSQL and tables aren't going to help significantly with an MDX issue.

Sounds like you may want to investigate Measure Expressions. Christian Wade wrote...

Can you post the entire mdx?