Microstrategy Analytics

Microstrategy Business Intelligence knowledge sharing platform

Search This Blog

Home
YTD, QTD, MTD, WTD table transformation SQL
MSTR VLDB Precedance levels
Joint Child Relationships in MSTR
Inputs for predictive metrics in Microstrategy
MSTR Passthough Functions; Applysimple, ApplyCompa...
Using linear and seasonal regression for Revenue F...
MSTR The key specified is the true key for the war...
MSTR Transformation Metric with no aggreagation
MSTR Defining sets of privileges: Security roles
MSTR VLDB SQL optimization tips
MSTR Restricting access to data: Security filters
MSTR Inventory metrics or No Aggregate metrics
MSTR Merge Report filter into metric symbols
MSTR Report Pre and Post Statements
Slowly changing dimensions
Level Metrics **** Easy to Understand****
Logistic Regression for Campaign Management
Hierarchy Reporting with Ragged Hierarchies
Filtering for a Level Metric
Applysimple in Metric
Conditional metric and report filter interactions
Connection Mappings in Microstrategy
MSTR Controlling access to data
Data Modelling issues with Split, Ragged and Recur...
Date functions specific to different databases
(YTD) transformations without using transformation...
many-to-many and joint child relationships
Logical Table Size the easy way to understand
Applycomparison advancd filter with a select state...
Adding an existing D3 Visualization

More…

Posts

Showing posts with the label Split Hierarchy

Show all

Precedence of VLDB properties in Microstrategy

July 06, 2018

Precedence of VLDB properties in Mocrostrategy #Microstrategy, #vldb #precedance

Get link
Facebook
X
Pinterest
Email
Other Apps

Labels

"Error type: Odbc error. Odbc operation attempted
"Object BaseAttributeForm has already been deleted" #baseattributeform
# #mstr dossier #What is dossier #microstrategy dossier #dossier #dossier visual insights
# Custom number formatting symbols
# Mstr element search # search not working
# star schema mstr
# true key
# url parameters
#.mstrc #connectionfile #microstrategyconnectionfile
#.mstrcconnectionfile

#.mstrsc #Generate a MicroStrategy Connection File to Connect
#Activate MicroStrategy Geospatial Services # geospacialservices
#Apply (Pass-Through) functions
#Apply Comparison #ApplyAgg #Applycompare #ApplyLogic #ApplyOLAP #Applysimple #mstrapply #apply
#applysimpledossier
#Attribute left outer join
#attribute with a form with Image URL #image URL #Microstrategy URL
#AutoText #MicrostrategyDocument Autotext codemacros #autotextmstr#mstrautotext #microstrategyautotext
#Beginning fact.
#Best Practices
#Best practices on how to reference an image specified using a relative path for exported documents in MicroStrategy
#blob
#bulk export
#Bulk Export in MicroStrategy #bulk export
#Bursting file #Bursting filemstr #burstmicrostratgey
#cache
#calculate logical table size
#Case functions #microstratgeycase
#Coalesce #Coalescemicrostrategy
#Command Manager Scripts in Microstrategy to create a user and add to a group #command manager add user #command manager add group
#Compound Key attribute
#Compound key attribute #Compound key attributemstr #Compound key attributemicrostratey
#compundkeymstr
#Configure Connection Mapping in Microstrategy #configureconnectionmapping #configuremapping
#ConfigureTransactionsEditor #transactionservices #mstrtransactionservices
#Connection Mapping in Microstrategy #connectionmapping
#consolidation
#containstableau #liketableau #tableaulikecontains #tableaulikeoperator #tableaucontainsoperator
#Control the display of null and zero metric values in a grid report #display of null # display of zero
#Creat transaction services photo uploader #transaction services
#Create Email Subscription in Microstrategy #email subscription
#Create your own Open source Agile boards
#Creates a schedule Microstrategy #schedule
#Creating a .mstrc file from an empty text file #mstrc #mstrcconnectionfile
#Creating a Microcharts widget in MSTR
#cubeincrementalrefreshmicrostrategy
#cubeincrental
#cuberefeshMicrostrategy
#Custom formatting attribute data Custom number formatting symbols
#custom formatting metric into millions 1M
#Custom group
#Custom group and consolidation comparison
#Custom Groups and Consolidations #customgroups #consolidations
#customsubtotal
#dashboard slow
#dashboardperformance
#Data Mart Reports in Microstrategy #datamart reports
#datablendingmstr #disaableblendingmstr #disable/enable data blending #datablending
#databricks microstrategy
#Delete Unused Managed Objects #deletemanaged#deletemanagedobjects
#Dervied metric using attributes #derivedmetricsusingattribute
#disable blending
#Display Percentage Sign in Tableau Graph #Percent sign tableau graph # graph
#Displaygouphorizontally #grouphorizontal #grouphorizontalmstr
#Displaying sections horizontally #sectionshorizontalmstr #mstr horizontal
#DistributionServicesMicrostrategy #bestpracticesDistributionServices ##DistributionServices
#Documents with derived attributes cannot be edited within MicroStrategy Developer 10.x #editdocumentgreyed
#dossier
#dossierhow
#dossiers
#duplicates
#Dynamic Custom Group
#dynamiccustomgroupmicrostrategy
#dynamiccustomgroupmstr
#email body and attachment
#Enable looading Intelligent Cubes when Intelligence Server Starts
#Ending fact
#Ending lookup
#error
#Error "Conversion failed when converting the varchar value 'xxxx' #conversion failed image #Error "Conversion failed
#Event-Triggered Schedules #eventtrigger #mstrevent #mstrtriggers
#Events and event-triggered schedules in Microstrategy #eventtriggers #event triggersmicrostratgey
#export delimited
#export images to pdf red x
#Export to Excel with formatting URL API
#exportexcelmicrostrategy
#Exporting large reports as delimited text files
#Fact level
#Fact tables level
#Fact tables levels in Microstrategy:
#filtering
#filters
#Filters and prompts in Microstrategy
#filtersprompts
#Fiscal Quarter and Fiscal Year calculations in Microstrategy #fiscal quarter #fiscal year # fiscal month
#fiscal week #Fiscal Week
#generate connection file #workstation connection #Microstrategy workstationconnection
#he results of a report are in the email body as HTML content and a different report
#heterogenious
#Homogeneous versus heterogeneous mapping microstrategy
#homogenious #Homogeneous
#How to enable the quick search for MicroStrategy Web e#nable quick search
#HTML Image to Exports Grid on a Document to Excel
#identify a record uniquely #Microstrategy Compound Key attribute
#ignore Report filters for a metric
#images not displayed on iphone email app microstrategy
#imageurl
#inline #manytomany #manytomanyinline
#invalidpicture
#iphone app images microstrategy
#Joint child relationships # mstr joint child # joint child
#layout #layout tab # remove layout
#left outer join
#leftouterjoinmicrostrategyweb
#leftouterjoinweb
#level metrics #level metrics in Microstrategy #MSTR level metrics
#library
#loadcubeswheniserverrestarts.
#logical size
#logicalviewleftouterjoin
#M million #Custom formatting metric values of 1
#Managed objects #mstrmanagedobjects#microstrategyManaged objects
#many to many relationships
#many2many
#mddoctor
#Metadata Doctor #mddoctor #mddoctormstr#mddocormicrostrategy
#metricouterjoin
#Metricvaluesrepeated
#Microcharts
#Microcharts widget in MSTR
#Microstrategy Dashboard performance #improvements steps
#Microstrategy Dashboard performance improvements steps:
#Microstrategy 9 uninstall #Microstrategy clean uninstall #Microstrategy uninstall
#Microstrategy Alerts setup #alerts setup #delivery settings
#Microstrategy algorithms
#Microstrategy Authentication Using the URL API #authentication mstr url api
#Microstrategy Best Practices
#Microstrategy custom group
#Microstrategy dashboard
#Microstrategy delimited file
#microstrategy filter
#Microstrategy hyper #hyperintelligence # hyper cards # hyperarchitecture #hyper #mstrhyper
#Microstrategy logical table size
#Microstrategy Pre and Post Statements
#Microstrategy Release Types #Microstrategy versions
#Microstrategy removing rows with Zero metric values #removezerometroc values # remove null metric values
#Microstrategy Report Services documents vs Dashboards #differences Microstrategy Report Services documents vs Dashboards # rsd and dashbioards
#Microstrategy URL API hide sections
#microstrategycube
#microstrategyfilters#typesoffilters #mstrfiltertypes
#microstrategysupercube
#Microstratgey 10 uninstall #Microstratgey Registry
#microstratgey left outer join
#Microstratgey nt authentication
#microstratgeylibrary
#mobileconfiguration
#mobilegenerateurl #mobileurl
#mstr Attribute left outer join
#MSTR complete uninstall
#MSTR dossiers #dossiers #microstrategy dossiers
#MSTR Performance
#mstr quick search
#mstrbestpractices #mstrbestpracticesschedulingjobs #mstrbestpracticesadministrative tasks
#mstrblob #microstrategyblob
#mstrcache
#mstrcase #Case #if
#mstrdataimport
#mstrfilters
#mstrio
#mstrmobile #mstrmobileurl #mstrgenerateurl
#mstrprompts
#mstrvideo
#mstrvideotutorials
#Multi-Table Data Import(MTDI) #MTDI
#nested prompts in MicroStrategy#nlevlnested #promptinprompt
#Non Aggregate metrics #Beginning lookup
#Normal form
#Normalization #First Normal Form #secondNormal Form #thirdNormal Form
#nt authentication
#OLAP#olapMSTR#OLAPMicrostrategy #olapfeatures
#olapcube
#order of tables in sql #Order of tables appear in the SQL generated by the MicroStrategy SQL Generation Engine
#Outer Join between metrics in MicroStrategy
#outerjoin
#outofmemory
#outofmemoryerror
#Personalizingemailfilesubscriptions #Personalizingfilelocations
#platform release #feature release
#pre statement # post statement # pre #post
#pre statements #post statements
#Predictive modelling
#Predictive modelling in MicroStrategy
#predictive models mstr
#Prompt-in-prompt (nested prompt) feature in a FreeForm SQL Report #prompt in prompt #nestedprompt # nestedpromptfreefor
#Prompt-in-prompt(Nested Prompts) in Microstrategy #Prompt-in-prompt # nested prompts
#promptinprompt #nestedprompt #promptinpromptmstr #nestedpromptmstr #nestedpromptMicrostrategy
#prompts
#Prompts in URL API #mstr urlapi
#prompttypes
#purge
#purgemstrwebcache
#purgewebmstr
#ragged
#Ragged Hierarchies Microstrategy
#Ragged Hierarchy
#raggedmstr #raggedmicrostratgey
#Recursive hierarchies microstrategy
#Recursive Hierarchy
#reducecubesize #icubesize#large cube
#redx export
#Relationship table
#release types mstr #release types microstrategy
#Removing sections no data
#repeatedmstr #manytomany #manytomanymstr
#Replace object names in bulk #repositorytranslationwizard #mstrtranslation #mstrlanguagetranslation
#report as filter
#report filter bypass
#report filter not applied #ignore filters
#report level
#Report Pre and Post Statements
#reportschedule #deliveryschedule
#Retrieve a list of user groups #mstr user list documentation
#runningsum
#Runningsum microstrategy
#runningsum on metric subtotal
#Save Personal View of Microstrategy Report/Dashboard #personal view
#scanmd #metadatainconsistancies#mstrscanmd#microstrategyscanmd
#Scheduling a report or document to be sent to an FTP server #mstr ftp send #ftp #file to ftp
#search doesn't get exact phrase
#SearchFreeformreports #searchfreeform
#show the hidden objects in the #MicroStrategy Developer Preferences options are expanded so big that some options are being cutoff.
#slices
#slicing
#slicing in Microstrategy #Applying selections as filters or slices
#Slowly Changing Dimension Types 0
#Sort by metric subtotals #Sort by metric subtotals and attribute elements together in Microstrategy
#sort order attribute browsing #MicroStrategy default sort order for an attribute elements browsing and display
#Spark SQLMicrostrategy
#sparkmicrostrategy
#sparkmstr
#split microstrategy
#splithierarchy #microstrategysplithierarchy #manytomany
#Standard filtering.#Absolutefiltering. #Ignore filtering #None
#Star schemas and aggregate (or summary) fact tables # aggregate # aggregate tables microstrategy # aggregate star mstr
#star schemas with MicroStrategy SQL Generation #star schema # star #star microstrategy # star mstr
#starschema #Microstrategymodelling
#subtotal
#Subtotals across level are displayed at the bottom of the of the grid report instead #subtotals # subtotal display
#supercube
#System Prompts #System Prompts in MicroStrategy
#Table structure cannot read or update #cannot read or update
#Tableau Connector to Microstrategy REST API URL #tableaumicrostrategy #tableaumicrostrategyconnector
#tables containing a particular column in the database
#The intersection of two subtotals is not calculated when running a report in MicroStrategy #intersection of subtotals #intersection of two subtotals blank
#The key specified is the true key for the warehouse table
#The URL parameter reportviewmode in Microstartegy
#Time-based and event-based schedules #timebasedschedules #eventbasedschedules
#transactionservices
#transactionservices #localtransactions
#transactionservices #useraccesstransactionservices #userprivilagetransaction #mstrtransactionservices
#transactionservicesmstr
#TransactionServicesTutorialvides
#troubleshooting in MicroStrategy #dashboard slow
#True key without aggregation
#Types of prompts in Microstrategy
#Types of result caches Microstrategy #Matching caches #History caches #Matching-History caches #XML caches
#unbalanced Hierarchy
#unknown #usedefault #varcharunknown #warehousecatalogue#warehousecatalogunknown
#updatetransaction
#URL API #vismode #viewmode
#URL API connection mode parameters
#url api parameters
#urlapi
#urlapimstr
#User privilege for a Transaction Services
#Userrequestiscompleted. #Ranoutof memory #outofmemoryerror
#Users are prompted for an NT authentication login and password when using Firefox with MicroStrategy web
#Using images in Microstrategy reports # images path #images relative path
#Using stored procedures within Freeform SQL reports in MicroStrategy # mstr stored procedure
#vi #visualinsights
#vicube
#VLDB properties.
#vlookip
#vlookupmicrostrategy
#vlookupmstr
#webcache #mstrweb ache #PurgeWebCachesMicroStrategyweb #mstrwebcache
#widget
000 into a 1.1 million 1.1M type format
100
11.1.19 Enterprise Applications
4
5
6 and 7 #scd # scd type 1 # scd type 2 #scd type 3 #scd
applysimple filter
attribute id with null values
automate integritymanager
automate System Manager workflow
BestPractices
bursting
bursting mstr
certify
certify dossiers
Certify dossiers in MicroStrategy
Certify dossiers in MicroStrategy Web
commandline
create alerts in mstr
Create an alert-based subscription
Create an alert-based subscription in mstr
dashboard performance
distribution alerts mstr
dossiers
Email bursting
Email bursting is in MicroStrategy
Email bursting mstr
Enable Incremental fetch
Enter a valid physical address
Enter a valid physical address error
Enter a valid physical address Microstrategy
Error. Engine Attribute Role Limit Exceeded
exportexcelbuttonmicrostrategy
exportexceldashboard
exporttoexcelmstrdocument.
Fiscal Month
grouping sections
Hadoop Hive Microstrategy
horizontal
HyperIntelligence
imageurlattribute
Incremental fetch MSTR
integrity manager
Integrity manager Command line
internationalization
invalid picture
join with null values
many to many relationships
Microstrategy
Microstrategy "Error type: Odbc error. Odbc operation attempted
Microstrategy Best Practices
Microstrategy dossiers
Microstrategy Incremental fetch
Microstrategy internationalization
Microstrategy invalid picture
Microstrategy section horizontal
microstrategy System Manager workflow
Microstrategy VLDB Properties
MicroStrategy VLDB properties with Hive
Microstrategyexcelexport
Microstrategyolapvssuper
microstrategyurlapiexcelexport
Microstratgeyouterjoin
misrostrategy HyperIntelligence
mstr
mstr 10 #uninstall #cleanuninstall
mstr dossiers
mstr filter types
mstr HyperIntelligence
mstr installation error
mstr invalid picture
mstr System Manager workflow
mstrscanmd
MSTRurlapiexcelexport
MSTRurlapipdfexport
multi language
Multi sourcing in freeform SQL
Multi-Select Drop Down Apply Button
Multi-Select Drop Down microstrategy
Multi-Select Drop Down Selector with OK Apply Button
multisource
null to 0
null to zero
nvl
Odbc error
Odbc operation attempted
olapcubessupercubes
olapvssuper
Optimizing queries in Microstrategy using VLDB properties
Outer Join between metrics
permissions to create alerts in mstr
predictivemetrics
schema loading error
sections
sections horizontally
Split Hierarchy
sql #promptinpromptfreeform sqlreport
Stop a Report delivery when there is no data
stop subscription no data
stop subscription no data in report mstr
Subscription no alert option
System Manager workflow
System Manager workflow to execute on a schedule
Tag Microstrategy Dossier
Tag Users
Tag Users in Microstrategy Dossier
The object shown in the following hierarchy no longer exists in schema:
Use Table Alias featureDSSSQLEngine
user has no option to create alert mstr
useraccesstransactionservices
VLDB
VLDB properties

Show more Show less

Powered by Blogger