February 13, 2017 at 10:05 am
Hello, I have a task to design into an existing tabular cube, what has been loosely spec'd out as something found in MDX cubes, the Member Properties, with such links to give the idea of what they want.
http://www.informit.com/articles/article.aspx?p=337135&seqNum=5
They want to establish a definition between a SPLUserID and for an Account Name which would also have or be tied in with an account number, SPLUser Name, and market segment. They want to establishing this definition to them to pull associated fields into look up files, something like a VLOOKUP in Excel when they call up the cube.
Looked up what they gave in in email and the links in two books, Applied MS SS 2012 SSAS - Teo Lachev, and MS SS 2012 AS BISM Tab Model - Marco Russo. I learned that they are thinking in terms of the links sent, the MD model. We have Tab cubes, so what I'm finding in MD world as Member Properties, is what I think is Named Calculations in a Data Sources View.
So as I dig into this, if anyone can please provide some guidance and direction on good sources for steps, process and procedure to step through to help me accomplish this task it's greatly appreciated. Thank you, JPQ
February 15, 2017 at 6:58 am
If you are looking at a Multi-Dimensional cube in Excel and hover over something with these properties, you get a nice pop-up with those additional values. Is that what you are talking about?
I don't think Tabular has that feature. Would be nice!
Have you looked at this from other angles? For example, what about a new field that concatenated the additional values needed?
I hope you don't give up on Tabular because of a few "missing" features. I think Microsoft favors Tabular (just my opinion). Tabular seems to be the natural fit for Power BI and Power Pivot.
February 15, 2017 at 8:04 am
I think you're spot on, they do favor and push the tab cubes, as that's what PowerPivot is, and that what it data gets turned into as it goes into PowerBI, and what the Cortana/NLQ runs on, a data set being in the Tab format. And after trying to get help through MS Premier support, bottom line, no, there isn't an equivalent to Member Properties in Tab's. I'd have to take the Excel Pivot, and cram that into a MD cube, and then do member Properties to it if I wanted that functionality.
February 15, 2017 at 8:22 am
I always try creativity and look for a different option before moving in a drastically different direction. Hope you find a good solution without too much headache 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply